¡¾»ã×Ü¡¿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
Ïà¹ØÎĵµ£º
º¯Êý¼ò½é:¡¡¡¡
·µ»Ø Variant (Long) µÄÖµ£¬±íʾÁ½¸öÖ¸¶¨ÈÕÆÚ¼äµÄʱ¼ä¼ä¸ôÊýÄ¿¡£
º¯ÊýÓï·¨:
¡¡¡¡DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
DateDiff º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÀ´¼ÆËãdate1 ºÍ date2 µÄʱ¼ä²îµÄʱ¼ä¼ ......
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 ......
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Îļþ£¬º¬¶à¸ösheet£¬Ã¿¸ösheetµÄÄÚÈݶÔÓ¦²åÈëµ½Ò»ÕÅ±í£¬sheetµÄÃû³Æ¾ÍÊǶÔÓ¦µÄ±íÃû³Æ¡£
ÿһÐÐΪÁÐÃû£¬ÀýÈ磺
´ï³É£º½«Ã¿¸ösheetÊä³ö³ÉÒ»¸öÒÔsheetÃû³ÆÃüÃûµÄsqlÎļþ£¬ÄÚÈÝΪÿÐÐÄÚÈݵÄinsertÓï¾ä¡£
ÒÔÉÏͼΪÀý»áÉú³ÉÈý¸ösqlÎļþ£¬·Ö±ðÊÇTF_R_TERMINAL_ARCH.sql£¬ TF_R_STOCK_TRADE.sql ºÍ TF_R_STOC ......
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 ......