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Óï¾äÔõôд°¡ ......
Çë½Ì¸ßÊÖ£º
ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ
id planname TaskBeginTime Status
329 2010Äê03 ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
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»áÓÐ ......