SQL Server 2008ʹÓà - MS-SQL Server / »ù´¡Àà
×î½ü×°Á˸öSQL Server 2008£»²»¹ýÎÒÓõÄÖ»Êǿͻ§¶Ë£¬Ò»¾ä¼òµ¥µÄselect * from table ×ÜÊÇÌáʾÎÞ·¨Æô¶¯T-SQLµ÷ÊÔ£»Î´½Óµ½·þÎñÆ÷£¬µÇ¼ʧ°Ü£»
µ«ÎÒÃ÷Ã÷¶¼¿´µ½ÉÏÃæµÄÊý¾Ý¿âºÍ±íÁË£»
ÔõôûÈËÖ§Õа¡
ûÓÐÓùý sql 08,°ï¶¥+ѧϰ¡£¡£¡£¡£¡£¡£ÅθßÊÖ½â´ð¡£¡£
¹ÖÊ£¬ÖØÆôSQL·þÎñÊÔÏ¡£
ÄãÓõÄʲôÕË»§µÇ¼µÄ£¿Èç¹ûÊÇwindowsÕË»§µÇ¼µÄ£¬ÊÔÊÔ¸ÄÓÃsql serverÕË»§µÇ¼£¬²¢ÇÒ±£Ö¤µÇ¼µÄÕË»§ÒªÓÐsql serverÖÐsysadminµÄȨÏÞ
¸Õ²ÅÊÔÁËÏ£¬°´ÄÇÀïÃæµÄÖ´Ðа´Å¥Ê±¾ÍÐÐÁË£¬°´µ÷ÊÔ¾ÍÊÇÉÏÃæËµµÄÎÊÌ⣻ÕâÊÇÔõô¸ãµÄ°¡?
¼ÌÐø¹Ø×¢¡£¡£°ï¶¥£¡
¾ÍûÈË»áÂð£¬Ã»ÈËÃ÷°×Âð£¿
¹þ¹þ¹þлл À´¿´¿´ ѧϰµÄ
¹Ø×¢Öа¡
ȷʵûÓÐÓöµ½¹ý¡£ °ï¶¥¡·¡£¡£
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
Çë½Ì¸ßÊÖ£º
ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ
id planname TaskBeginTime Status
329 2010Äê03 ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
select o_customer,o_price from orders having o_price >=avg(o_price)
select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders)
ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......