³õѧsql ÓÃʲôÈí¼þ - MS-SQL Server / »ù´¡Àà
»ù´¡¼¸ºõΪÁã ×Ôѧ »¹ÓÐÏ£ÍûÄÜÍÆ¼öЩÊé ͬʱ»¹ÔÚѧc#
sql server 2000 sql server 2000²»ÒªÕÛÌÚÌ«¾Ã£¬È»ºó¾Í2005£¬ ÖÁÓÚÊé¼®£¬¿ÉÒÔÏÈÖ±½Ó ¿´sql serverµÄ°ïÖú http://www.w3school.com.cn/sql/sql_distinct.asp ÕâÍøÕ¾Àï¶¼ÊÇЩ»ù´¡£¬ºÜÊʺÏÐÂÊÖ¿´¡£ ÎÒ¸øÄãÒ»¸öÁ´½Ó£¬µ±ÄãÐèÒªµÄʱºò£¬Äã»á»ØÀ´¿´ËüµÄ¡£ http://topic.csdn.net/u/20091013/15/9F058DF7-4D29-47BF-A338-B63FCAB2ABC0.htmlÒýÓà »ù´¡¼¸ºõΪÁã ×Ôѧ »¹ÓÐÏ£ÍûÄÜÍÆ¼öЩÊé ͬʱ»¹ÔÚѧc# ÊÓÆµÏÂÔØÁã»ù´¡Ñ§SQL (http://topic.csdn.net/u/20100301/16/43bbbcfa-2f44-4499-81b0-946529d793c5.html?42542) ¾ø¶ÔµÄ¸ßÇå°æ±¾£¬Ò²ÊÇÄѵÃ×ÊÔ´¡£ºÜÉÙÓÐϵͳ½²½âSQLÓïÑÔ£¬²¢ÇÒ»¹¶ÔSQL Server¡¢MySQL¡¢Oracle¶¼×öÁËÀ©Õ¹½éÉܵġ£ ÏÂÔØµØÖ·£º http://u.115.com/file/f630f1a16c ÍøÂçUÅ̱£´æÆÚÊÇ30Ìì¡£ÓÐÐËȤµÄ£¬Ç뾡¿ìÏÂÔØ¡£ Êý¾Ý¿âѧϰÊÓÆµºÍ×ÊÁÏÏÂÔØ http://topic.csdn.net/u/20081116/23/c8e88244-af30-466c-a563-9f569c4fdd86.html sql server 2005ÒýÓà sql server 2005 UP ~~~~ Èç¹ûûÓÐѧ¹ý Ö±½ÓѧϰSQL 2005ºÃÁËÒýÓà Èç¹ûûÓÐѧ¹ý Ö±½ÓѧϰSQL 2005ºÃÁË F´ó½ã¡£¡£ ÎÒµÄÌâÄ¿¡£¡£¡£ ²»È»ÎÒ¾Í Ð»Ð»¸÷λ ÎÒÈ¥ÏÂÁ˸ösql server 2005 °²×°ºóÔÚ¿ªÊ¼ÀïÃæÕÒ²»µ½ÄǸö ʲômanagement studio£¨Ó¦¸ÃÊÇ
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£ 2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ ) ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ. sqltext="select top A * from log where id not in(select top ( ......
ÓÐ2¸öÊý¾Ý±íAÓëB£¬ÈçºÎ²¹³äAÖÐûÓÐ,BÖÐÓеÄÊý¾Ý£¬Ê¹A±íÊý¾ÝÍêÕû£¿ÇëдϾßÌåÔ´´úÂë SQL code: insert A select * from A right join B on A.key=b.key where A.key is null select * from B left join ......