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
Declare @endtime as datetime
Declare @result as int
Begin
set @starttime = getdate()
--- 측정할 쿼리 ---
set @endtime = getdate()
set @result = datediff(ms,@starttime,@endtime)
select @result
End