SQL Server ÈÕÆÚºÍʱ¼äº¯Êý
1¡¢³£ÓÃÈÕÆÚ·½·¨(ÏÂÃæµÄGetDate() = '2006-11-08 13:37:56.233')
(1)DATENAME ( datepart ,date )
·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®¡£DatepartÏê¼ûÏÂÃæµÄÁбí.
SELECT DateName(day,Getdate()) –·µ»Ø8
(2)DATEPART ( datepart , date )
·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄÕûÊý¡£
SELECT DATEPART(year,Getdate()) –·µ»Ø2006
(3)DATEADD (datepart , number, date )
·µ»Ø¸øÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¸öʱ¼ä¼ä¸ôºóµÄÐÂdatetime Öµ¡£
SELECT DATEADD(week,1,GetDate()) --µ±Ç°ÈÕÆÚ¼ÓÒ»ÖܺóµÄÈÕÆÚ
(4)DATEDIFF ( datepart , startdate , enddate )
·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚ±ß½çÊýºÍʱ¼ä±ß½çÊý¡£
SELECT DATEDIFF(month,'2006-10-11','2006-11-01') --·µ»Ø1
(5)DAY ( date )
·µ»ØÒ»¸öÕûÊý£¬±íʾָ¶¨ÈÕÆÚµÄÌìdatepart ²¿·Ö¡£
SELECT day(GetDate()) –·µ»Ø8
(6)GETDATE()
ÒÔdatetime ÖµµÄSQL Server 2005 ±ê×¼ÄÚ²¿¸ñʽ·µ»Øµ±Ç°ÏµÍ³ÈÕÆÚºÍʱ¼ä¡£
SELECT GetDate() --·µ»Ø2006-11-08 13:37:56.233
(7)MONTH ( date )
·µ»Ø±íʾָ¶¨ÈÕÆÚµÄ“Ô”²¿·ÖµÄÕûÊý¡£
SELECT MONTH(GETDATE()) --·µ»Ø11
(8)YEAR ( date )
·µ»Ø±íʾָ¶¨ÈÕÆÚµÄ“Äꔲ¿·ÖµÄÕûÊý¡£
SELECT YEAR(GETDATE()) --·µ»Ø2006
2¡¢È¡Ìض¨ÈÕÆÚ
(1)»ñµÃµ±Ç°ÈÕÆÚÊÇÐÇÆÚ¼¸
SELECT DateName(weekday,Getdate()) --Wednesday
(2)¼ÆËãÄÄÒ»ÌìÊDZ¾ÖܵÄÐÇÆÚÒ»
SELECT DATEADD(week, DATEDIFF(week,'1900-01-01',getdate()), '1900-01-01') --·µ»Ø2006-11-06 00:00:00.000
»ò
SELECT DATEADD(week, DATEDIFF(week,0,getdate()),0)
(3)µ±Ç°¼¾¶ÈµÄµÚÒ»Ìì
SELECT DATEADD(quarter, DATEDIFF(quarter,0,getdate()), 0)—·µ»Ø2006-10-01 00:00:00.000
(4)ÈçºÎÈ¡µÃij¸öÔµÄÌìÊý
SELECT Day(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,'2006-02-03')+1,0))) —·µ»Ø28
(5)Ò»¸ö¼¾¶È¶àÉÙÌì
declare @m tinyint,@time smalldatetime
select @m=month(getdate())
select @m=case when @m between 1 and 3 then 1
when @m between 4 and 6 then 4
 
Ïà¹ØÎĵµ£º
SOURCE: CLICK HERE
±¾ÎĽ²ÊöSQL Server¡¢Oracle¡¢MySQL²é³öֵΪNULLµÄÌæ»»¡£
ÔÚSQL Server Oracle MySQLµ±Êý¾Ý¿âÖвé³öijֵΪNULLÔõô°ì?
1¡¢MSSQL: ISNULL()
Óï·¨
ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
re ......
--±¸·ÝÊÂÎñÈÕÖ¾ (×ÔÉÏÒ»´Î±¸·ÝÒÔÀ´£¬ÖÁµ±Ç°µÄÒÑÍê³ÉµÄÊÂÎñµÄÈÕÖ¾)
backup log MyDBName to disk='F:\dbbak\GamePoint\MyDBName_log_2010052709.bak';
--½Ø¶ÏÈÕÖ¾(½Ø¶Ïµôµ±Ç°µÄÒÑÍê³ÉµÄÊÂÎñµÄÈÕÖ¾), SQL Server 2005, 2008ûÓÐÕâ¸öÑ¡Ïî.
backup log MyDBName with no_Log;
--ÊÕËõÈÕÖ¾(ÖÁ1M,µ ......
ÔÚSQL Server Unicode×Ö·û´®³£Á¿ÐèҪǰ׺N
µ±ÔÚSQL
SERVERÀï±ß´¦Àí×Ö·û´®³£Á¿µÄʱºòÄã±ØÐëÔÚ³£Á¿Ö®Ç°·ÅÒ»¸ö´óдµÄN,¾ÍÏñSQL
SERVERÁ¬»úÎĵµ±êÌâΪ"²ÉÓÃUnicodeÊý¾Ý"Ëù˵Ã÷µÄÄÇÑù.Nǰ׺ÏóÕ÷×ÅÔÚSQL-92
±ê×¼µÄ¹ú¼ÒÓïÑÔ,²¢ÇÒ±ØÐëÊÇ´óд×Öĸ.Èç¹ûÄãÔ ......
¶ÔÓںܶàDBAºÍ³ÌÐòÔ±À´Ëµ£¬SQL ServerÖеÄË÷Òý²»ÊÇÒ»¸öİÉúµÄÊÂÎÎÒÃÇÉõÖÁÿÌì¶¼ÔÚʹÓÃËü£¬¶ÔÓÚÄÄЩÇé¿öÏÂÓ¦¸Ã´´½¨Ë÷Òý¶¼ÄÜÒ»Ò»µÄµÀ³ö£¬²»¹ýÓпÉÄÜÎÒÃDz¢Ã»ÓÐ×ÐϸȥÏëËüµÄ¾ßÌåÔÀí£¬±¾ÎĽ«¸ù¾ÝÎÒ¶ÔSQL ServerÖеÄË÷ÒýµÄÀí½â×öÒ»¸ö¼òµ¥µÄ×ܽáºÍ¸ÅÊö£¬Ï£Íû¶Ô´ó¼ÒÄÜÓÐËù°ïÖú£¨Ïêϸ¿É²Î¿¼¡¶SQL Server 2005 Implementation an ......
/*
--2010-05-27(¶«Éý)
SQL SERVER 2008 ÐÂÊý¾Ý¿âÀàÐÍhierarchyid
SQL SERVER 2008ÒýÈëÁËеÄhierarchyidÊý¾ÝÀàÐÍ,¿ÉÒÔÓÃËüÀ´×ö±¾µØ´æ´¢²¢ÇÒÔÚÊ÷²ã´Î
½á¹¹ÖйÜÀíÆäλÖÃ.Ö»ÓÃÕâ¸öº¯ÊýÄܼò½àµØ±íʾ²ã´Î½á¹¹ÖеÄλÖÃ.¸Ãº¯ÊýÌṩµÄһЩ ......