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

³õѧ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£¨Ó¦¸ÃÊÇ


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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 ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

¹ØÓÚVbÖÐsqlÓï¾äµÄд·¨£¨100·Ö£© - Java / Web ¿ª·¢

Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò
ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ.
sqltext="select top A * from log where id not in(select top ( ......

SQL ÎÊÌâ - MS-SQL Server / »ù´¡Àà

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