declare @BeginTime datetime
declare @EndTime datetime
set @BeginTime = getdate()
--one or more sql statements
declare @EndTime datetime
set @BeginTime = getdate()
--one or more sql statements
set @BeginTime = getdate()
select @BeginTime
select @BeginTime
select @BeginTime - @BeginTime
================================
declare @date1 datetime
declare @date2 datetime
select @date1=getdate()
--测试语句
select @date2=getdate()
select datediff(millisecond, @date1, @date2)
--结果是毫秒数
转自http://www.cnblogs.com/zp89850/archive/2008/01/14/1037960.html