SELECT CAST('2003-05-08 12:35:29.998' AS smalldatetime);

SELECT CAST('2003-05-08 12:35:29.999' AS smalldatetime);

select cast(12 as char(2))+cast(13 as char(2))

select DATEPART("yy",GETDATE())   --返回日期中的年數(shù)

select DATEPART("mm",GETDATE())

select DATEPART("dd",GETDATE())

select DATEPART("hh",GETDATE())

select DATEPART("n",GETDATE())     --返回日期中的分鐘數(shù)

select cast(DATEPART("hh",'2003-05-08 20:35:29.999') as char(2))+':'+cast(DATEPART("n",GETDATE()) as char(2))

select year(getdate())

select month(getdate())

select day(getdate())

select getdate()

select left(getdate(),10)

select right(getdate(),8)

select left(CAST(getdate() AS smalldatetime),10)

select right(CAST(getdate() AS smalldatetime),8)

select DATEDIFF("dd", '8/1/2003', '8/8/2003')     --計算間隔天數(shù)

select DATEDIFF("mm", '3/1/2011',GETDATE())       --返回間隔月數(shù)

select DATEDIFF("yy", '3/1/2010',GETDATE())       --返回間隔月數(shù)

select DATEDIFF("week", '7/1/2011',GETDATE())     --返回間隔周數(shù)

select DATEDIFF("hour", '7/21/2011',GETDATE())    --返回間隔月數(shù)

select DATEDIFF("dayofyear", '7/1/2011',GETDATE())    --返回間隔天數(shù)

select DATEDIFF("weekday", '7/1/2011',GETDATE())      --返回間隔天數(shù)

select DATEDIFF("minute", '7/21/2011',GETDATE())  

select DATEDIFF("second", '7/21/2011',GETDATE())

SET DATEFORMAT mdy;     --設(shè)置日期格式為mdy

SET DATEFORMAT ymd;

declare @start smalldatetime

select @start=cast(cast(DATEPART("yy",GETDATE()) as char(4))+'-'+cast(DATEPART("mm",GETDATE()) as char(2))+'-'+cast(DATEPART("dd",GETDATE()) as char(2))+' '+starttime as smalldatetime) from userpathinfo where pathid= 564

select @start

select dateadd(month,2,@start)

SELECT DATENAME(month, GETDATE()) AS 'Month Name'

SELECT DATENAME(weekday, GETDATE())   --返回星期名稱，如星期三

select dateadd(month,-1,getdate())     --在向指定日期加上一段時間的基礎(chǔ)上，返回新的datetime 值

select replace('大連XXXX公司大連XXXX辦事處','大連','北京')

select convert(varchar,getdate(),112)   -- 如：20110902

select cast(cast(DATEPART("yy",GETDATE()) as char(4))+'-'+cast((DATEPART("mm",GETDATE())-1) as char(2))+'-'+cast(1 as char(2)) as smalldatetime)

if 5!=4

print 'y > z'

else 

print 'y < z'

--獲得有關(guān)存儲過程的信息

--若要顯示Transact-SQL 存儲過程的定義，請使用該過程所在的數(shù)據(jù)庫中的sys.sql_modules 目錄視圖。

USE AdventureWorks;

GO

SELECT definition

FROM sys.sql_modules

JOIN sys.objects ON sys.sql_modules.object_id = sys.objects.object_id AND TYPE = 'P';

exec getalluserinfo    --執(zhí)行存儲過程

EXECUTE HumanResources.usp_GetEmployees 'Ackerman', 'Pilar';

-- Or

EXEC HumanResources.usp_GetEmployees @lastname = 'Ackerman', @firstname = 'Pilar';