sql serverÈÕÆÚʱ¼äº¯Êý
Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä±ß½çÊý¡£
select datediff(day,'2004-09-01','2004-09-18') --·µ»Ø£º17
4. datepart ·µ»Ø´ú±íÖ¸¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄÕûÊý¡£
SELECT DATEPART(month, '2004-10-15') --·µ»Ø 10
5. datename ·µ»Ø´ú±íÖ¸¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®
SELECT datename(weekday, '2004-10-15') --·µ»Ø£ºÐÇÆÚÎå
6. day(), month(),year() --¿ÉÒÔÓëdatepart¶ÔÕÕÒ»ÏÂ
select µ±Ç°ÈÕÆÚ=convert(varchar(10),getdate(),120)
,µ±Ç°Ê±¼ä=convert(varchar(8),getdate(),114)
select datename(dw,'2004-10-15')
select ±¾ÄêµÚ¶àÉÙÖÜ=datename(week,'2004-10-15')
,½ñÌìÊÇÖܼ¸=datename(weekday,'2004-10-15')
º¯Êý ²ÎÊý/¹¦ÄÜ
GetDate( ) ·µ»ØÏµÍ³Ä¿Ç°µÄÈÕÆÚÓëʱ¼ä
DateDiff (interval,date1,date2) ÒÔinterval Ö¸¶¨µÄ·½Ê½£¬·µ»Ødate2 Óëdate1Á½¸öÈÕÆÚÖ®¼äµÄ²îÖµ date2-date1
DateAdd (interval,number,date) ÒÔintervalÖ¸¶¨µÄ·½Ê½£¬¼ÓÉÏnumberÖ®ºóµÄÈÕÆÚ
DatePart (interval,date) &n
Ïà¹ØÎĵµ£º
--Óï ¾ä¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT¡¡¡¡¡¡--ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE¡¡¡¡¡¡--¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE¡¡¡¡--´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER ......
Ö´ÐÐÊý¾Ý²Ù×÷ʱ£¬ÓÉÓÚÆ´½ÓSQL´æÔÚÖÖÖÖ±×¶Ë£¬Ôç¾ÍÓ¦¸ÃÅׯúÁË£¬µ«ÔÚÏÖʵ¿ª·¢Ê±£¬ÓÖÓÉÓÚÖÖÖÖÔÒò£¬¹«Ë¾Ò»Ö±²ÉÓÃÕâÖÖ·½Ê½£¨UI²ãºÍÂß¼²ã¶¼ÓÐÑϸñµÄ¹ýÂË£¬µ¹Ò²Ã»³öÏÖ¹ýʲôÎÊÌ⣩£¬µ«×òÌ쿪·¢Ê±È´³öÏÖÁËÒâÏë²»µ½µÄÎÊÌ⣬һ¸ö¼òµ¥µÄÓï¾ä»áÔì³ÉÑÏÖØºó¹û¡£¼òµ¥µÄÓï¾äʾÀýÈçÏ£º
/// <summary>
&nb ......
--> Title : SQL Server 2005ÖеÄÎļþºÍÎļþ×é(¶þ)
--> Author : wufeng4552
--> Date : 2010-1-13
SQL Server 2005ÖеÄÎļþºÍÎļþ×é(¨ç) Ö÷Òª講½âÁËÀí論²¿·Ö
http://blog.csdn.net/wufeng4552/archive/2009/10/23/4716053.aspx
SQL Server 2005ÖеÄÎļþºÍÎļþ×é(¶þ) Ö÷Òª ......
¸ÕÔÚ¿´Ê飬Ìáµ½ÁËsql serverµÄģʽƥÅäÔËË㣬½Ó×ÅÏëµ½ÁËͨÅä·ûµÄתÒåÎÊÌ⣬ÒòΪ̫¾ÃûÓã¬GoogleÁËËÑË÷ÁËһϲÅÏëÆðÀ´£¬Ð´¼¸¾ä»°¼Ç¼Ï¡£ ¹ØÓÚͨÅä·ûµÄתÒ壬sql serverÀï±ßÌṩÁ˹ؼü×ÖescapeÀ´´¦Àí¡£µ«ÊÇescape±¾Éí²»ÊÇʲôתÒå·û£¨¸Õ²ÅÎÒ¾ÍÊÇÔÚÕâÀï¸ã´íÁË£©£¬¶øÊǽ«escapeºóÃæµÄ·ûºÅ¶¨ÒåΪתÒå·û¡£¾Ù¸öÀý£º select ......
ǰÁ½ÌìÒ»¸öѧ½ãÎÊÎÒ¸öSQLÓï¾äµÄÎÊÌ⣬ÏÖÔڰѽâ¾ö·½°¸Ìù³öÀ´£¬Ò²Ëã×ܽáһϰɡ£
ËýµÄÎÊÌâÊÇ£º“Ò»¸ö±íÖÐÓÐ15¸ö×ֶΣ¬ÓÃSQLÓï¾äÅÐ¶ÏÆäÖÐ5Ïî»òÒÔÉϲ»Îª¿Õ£¬ÔõôÅжϣ¬ºÜ¼±……”¡£
µ±Ê±Î񼆾£¬Ã»¶à¿´£¬ºÇºÇ£¬²»¹»Òâ˼À²¡£µ«ÎÒÇëͬʰïËýдÁ˸ö£¬ÒÔ½âȼü֮¼±£¬ÔÚ´ËҲллСÃס£
½ñÌìÔÙ°ÑQQÁÄÌì¼Ç¼· ......