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

¡¾»ã×Ü¡¿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


Ïà¹ØÎĵµ£º

SQLÓï¾äÖÐDateDiffº¯Êý˵Ã÷

º¯Êý¼ò½é:¡¡¡¡
     ·µ»Ø Variant (Long) µÄÖµ£¬±íʾÁ½¸öÖ¸¶¨ÈÕÆÚ¼äµÄʱ¼ä¼ä¸ôÊýÄ¿¡£
º¯ÊýÓï·¨:
¡¡¡¡DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
DateDiff º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÀ´¼ÆËãdate1 ºÍ date2 µÄʱ¼ä²îµÄʱ¼ä¼ ......

ÍøÕª£­SQL Server 2008 Êý¾Ý¿âÈÕÖ¾Çå³ýÃüÁî

 USE [master]
    GO
    ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE WITH NO_WAIT
    GO
    ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE
    GO
    USE [Database_Name]
  &nb ......

sqlÖÐ in ¡¢not in ¡¢exists¡¢not exists Ó÷¨ºÍ²î±ð

exists £¨sql ·µ»Ø½á¹û¼¯ÎªÕ棩
not exists (sql ²»·µ»Ø½á¹û¼¯ÎªÕ棩
ÈçÏ£º
±íA
ID NAME
1    A1
2    A2
3  A3
±íB
ID AID NAME
1    1 B1
2    2 B2
3    2 B3
±íAºÍ±íBÊÇ£±¶Ô¶àµÄ¹ØÏµ A.ID => B.AID
......

½«Excelת»»³ÉsqlÎļþ£¬²åÈëÊý¾Ý¿â

ÐèÇó£ºÓÐexcelÎļþ£¬º¬¶à¸ösheet£¬Ã¿¸ösheetµÄÄÚÈݶÔÓ¦²åÈëµ½Ò»ÕÅ±í£¬sheetµÄÃû³Æ¾ÍÊǶÔÓ¦µÄ±íÃû³Æ¡£
 Ã¿Ò»ÐÐΪÁÐÃû£¬ÀýÈ磺
´ï³É£º½«Ã¿¸ösheetÊä³ö³ÉÒ»¸öÒÔsheetÃû³ÆÃüÃûµÄsqlÎļþ£¬ÄÚÈÝΪÿÐÐÄÚÈݵÄinsertÓï¾ä¡£
ÒÔÉÏͼΪÀý»áÉú³ÉÈý¸ösqlÎļþ£¬·Ö±ðÊÇTF_R_TERMINAL_ARCH.sql£¬ TF_R_STOCK_TRADE.sql ºÍ TF_R_STOC ......

SQL SERVER convertº¯ÊýÈÕÆÚ¸ñʽ»¯Ó¦ÓÃ

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ