Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL Server 2008ʹÓà - MS-SQL Server / »ù´¡Àà

×î½ü×°Á˸öSQL Server 2008£»²»¹ýÎÒÓõÄÖ»Êǿͻ§¶Ë£¬Ò»¾ä¼òµ¥µÄselect * from table ×ÜÊÇÌáʾÎÞ·¨Æô¶¯T-SQLµ÷ÊÔ£»Î´½Óµ½·þÎñÆ÷£¬µÇ¼ʧ°Ü£»
µ«ÎÒÃ÷Ã÷¶¼¿´µ½ÉÏÃæµÄÊý¾Ý¿âºÍ±íÁË£»
ÔõôûÈËÖ§Õа¡

ûÓÐÓùý sql 08,°ï¶¥+ѧϰ¡£¡£¡£¡£¡£¡£ÅθßÊÖ½â´ð¡£¡£

¹ÖÊ£¬ÖØÆôSQL·þÎñÊÔÏ¡£

ÄãÓõÄʲôÕË»§µÇ¼µÄ£¿Èç¹ûÊÇwindowsÕË»§µÇ¼µÄ£¬ÊÔÊÔ¸ÄÓÃsql serverÕË»§µÇ¼£¬²¢ÇÒ±£Ö¤µÇ¼µÄÕË»§ÒªÓÐsql serverÖÐsysadminµÄȨÏÞ

¸Õ²ÅÊÔÁËÏ£¬°´ÄÇÀïÃæµÄÖ´Ðа´Å¥Ê±¾ÍÐÐÁË£¬°´µ÷ÊÔ¾ÍÊÇÉÏÃæËµµÄÎÊÌ⣻ÕâÊÇÔõô¸ãµÄ°¡?

¼ÌÐø¹Ø×¢¡£¡£°ï¶¥£¡

¾ÍûÈË»áÂð£¬Ã»ÈËÃ÷°×Âð£¿

¹þ¹þ¹þлл À´¿´¿´ ѧϰµÄ

¹Ø×¢Öа¡

ȷʵûÓÐÓöµ½¹ý¡£ °ï¶¥¡·¡£¡£


Ïà¹ØÎÊ´ð£º

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

SQLÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

Çë½Ì¸ßÊÖ£º
 ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ  
  id planname TaskBeginTime Status
329 2010Äê03 ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......

sqlÓï¾äÎÊÌâ - Java / Web ¿ª·¢

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»áÓÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ