³õѧ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
ÊÓÆµÏÂÔØÁã»ù´¡Ñ§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
UP ~~~~
Èç¹ûûÓÐѧ¹ý Ö±½ÓѧϰSQL 2005ºÃÁË
F´ó½ã¡£¡£
ÎÒµÄÌâÄ¿¡£¡£¡£
²»È»ÎÒ¾Í
лл¸÷λ ÎÒÈ¥ÏÂÁ˸ösql server 2005
°²×°ºóÔÚ¿ªÊ¼ÀïÃæÕÒ²»µ½ÄǸö ʲômanagement studio£¨Ó¦¸ÃÊÇ
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
×Ö¶Î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Êý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......