³õѧ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£¨Ó¦¸ÃÊÇ
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
ÏÂÃæÊÇXML³õʼÎļþÄÚÈÝ
XML code:
<upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......