Database/MSSQL

쿼리수행시간 측정

BAGE 2006. 7. 18. 07:14
Declare @starttime as datetime
Declare @endtime as datetime
Declare @result as int

Begin
set @starttime = getdate()
--- 측정할 쿼리 ---

set @endtime = getdate()

set @result = datediff(ms,@starttime,@endtime)

select @result
End