Friday, 3 July 2009

SQL start end time timing

declare @starttime datetime
set @starttime = getdate()

--SQL

print ' ... substring took ' + cast(datediff(ms,@starttime,getdate()) as varchar) + 'ms'
set @starttime = getdate()

0 comments: