¡¾»ã×Ü¡¿SQL CODE     ¾µä·¾«²Ê
	
    
    
	Êý¾Ý²Ù×÷Àà SQLHelper.cs 
http://www.cnblogs.com/zengxiangzhan/archive/2009/12/31/1636871.html
ÎÞÏÞ¼¶·ÖÀà ´æ´¢¹ý³Ì 
http://www.cnblogs.com/zengxiangzhan/archive/2010/01/04/1639220.html
°ÙÍò¼¶·ÖÒ³´æ´¢ 
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/12/1565313.html
SQL¾µä¶ÌС´úÂëÊÕ¼¯ 
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/12/1565320.html
ѧÉú±í ¿Î³Ì±í ³É¼¨±í ½Ìʦ±í 50¸ö³£ÓÃsqlÓï¾ä 
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/23/1572276.html
SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»» 
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/15/1567329.html
 
Óαê 
http://www.cnblogs.com/zengxiangzhan/archive/2010/01/03/1638165.html
¸ù¾Ý²»Í¬µÄÌõ¼þ²éѯ²»Í¬µÄ±í 
http://www.cnblogs.com/zengxiangzhan/archive/2009/12/05/1617458.html
INNER JOIN Óï·¨ 
http://www.cnblogs.com/zengxiangzhan/archive/2009/12/04/1617186.html
master.dbo.spt_values µÄÃîÓÃ
http://www.cnblogs.com/zengxiangzhan/archive/2009/11/24/1609197.html
¹ØÓÚSQLʱ¼äÀàÐ͵ÄÄ£ºý²éѯ 
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/23/1572286.html
ÅÅÃû sql 
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/23/1572290.html
 
ͬ²½Á½¸öÊý¾Ý¿â 
http://www.cnblogs.com/zengxiangzhan/archive/2009/11/15/1603267.html
QLServerºÍOracle³£Óú¯Êý¶Ô±È 
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/17/1568816.html
¹úÄÚ×îÐÂ×îÈ«ÃæIPÊý¾Ý¿â 
http://www.cnblogs.com/zengxiangzhan/archive/2010/03/21/1691051.html
sql ÏȽøÏȳö ¿â´æ 
http://www.cnblogs.com/zengxiangzhan/archive/2009/11/22/1608079.html
BOM ´´½¨Óû§¶¨Ò庯Êý,ÿ¸ö×Ó½Úµãde¸¸½ÚµãµÄÐÅÏ¢ 
http://www.cnblogs.com/zengxiangzhan/archive/2010/01/04/1639181.html
ÓÃPARSENAMEº¯Êý²ð·Ö×Ö·û´® 
http://www.cnblogs.com/zengxiangzhan/archive/2010/01/03/1638183.html
½«Ò»¸ö×Ö·û´®·Ö³É¶àÁÐ 
http://www.cnblogs.com/zengxiangzhan/archive/2010/01/03/1638172.html
×Ö·û´®·Ö¸îº¯Êý--²ð·Ö³É¶àÐÐ 
http://www.cnblogs.com/zengxiangzhan/archive/2010/01/03/1638171.html
ºÏ²¢¶àÐеÄijһÁÐÖµ 
http://www.cnblogs.com/zengxiangzhan/archive/20
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    1 Âß¼Êý¾Ý¿âºÍ±íµÄÉè¼Æ 
Êý¾Ý¿âµÄÂß¼Éè¼Æ¡¢°üÀ¨±íÓë±íÖ®¼äµÄ¹ØÏµÊÇÓÅ»¯¹ØÏµÐÍÊý¾Ý¿âÐÔÄܵĺËÐÄ¡£Ò»¸öºÃµÄÂß¼Êý¾Ý¿âÉè¼Æ¿ÉÒÔΪ 
ÓÅ»¯Êý¾Ý¿âºÍÓ¦ÓóÌÐò´òÏÂÁ¼ºÃµÄ»ù´¡¡£ 
±ê×¼»¯µÄÊý¾Ý¿âÂß¼Éè¼Æ°üÀ¨ÓöàµÄ¡¢ÓÐÏ໥¹ØÏµµÄÕ±íÀ´´úÌæºÜ¶àÁеij¤Êý¾Ý±í¡£ÏÂÃæÊÇһЩʹÓñê×¼»¯ 
±íµÄһЩºÃ´¦¡£ 
A:ÓÉÓÚ±íÕ£¬Òò´Ë¿ÉÒÔʹŠ......
	
    
        
    
    ÓÉÓÚÍøÕ¾ÊDZðÈ赀 
sql server  2000 ²»Äܵ¼Èë2005 µÄÊý¾Ý¿âÎļþ ÎÒÖ»ºÃ°´ÕÕÊéÉÏÖØÐ½¨Á¢µÄÊý¾Ý¿âÎļþ
È»ºóÔÚvisual studio 2005ÖÐÒ»¸öÒ»¸öµÄ¸´ÖÆ´æ´¢¹ý³Ìµ½sql server 2000
ÕâÑù¾Í²»ÓÃÏÂÔØ sql server 2005 ÁË
Èç¹ûÓÐsql server 2005 µÄ»°Ö®¼ÊÉú³É ½Å±¾¾ÍÒ»ÖÂÐÔµ¼Èë¾ÍokÁË ......
	
    
        
    
    ÐèÇó£ºÓÐexcelÎļþ£¬º¬¶à¸ösheet£¬Ã¿¸ösheetµÄÄÚÈݶÔÓ¦²åÈëµ½Ò»ÕÅ±í£¬sheetµÄÃû³Æ¾ÍÊǶÔÓ¦µÄ±íÃû³Æ¡£
 Ã¿Ò»ÐÐΪÁÐÃû£¬ÀýÈ磺
´ï³É£º½«Ã¿¸ösheetÊä³ö³ÉÒ»¸öÒÔsheetÃû³ÆÃüÃûµÄsqlÎļþ£¬ÄÚÈÝΪÿÐÐÄÚÈݵÄinsertÓï¾ä¡£
ÒÔÉÏͼΪÀý»áÉú³ÉÈý¸ösqlÎļþ£¬·Ö±ðÊÇTF_R_TERMINAL_ARCH.sql£¬ TF_R_STOCK_TRADE.sql ºÍ TF_R_STOC ......
	
    
        
    
    --SQL Server£º
Select TOP N * from TABLE Order By NewID() 
--Access£º
Select TOP N * from TABLE Order By Rnd(ID)  
Rnd(ID) ÆäÖеÄIDÊÇ×Ô¶¯±àºÅ×ֶΣ¬¿ÉÒÔÀûÓÃÆäËûÈκÎÊýÖµÀ´Íê³É£¬±ÈÈçÓÃÐÕÃû×Ö¶Î(U ......