原文地址：http://blog.csdn.net/wangjunhe/article/details/7211974
--利用getdate
declare @beginTime datetime declare @endTime datetime set @beginTime = getdate() select * from dbo.DatabaseLog set @endTime = getDate() select datediff(ms, @beginTime, @endTime) as MS GO
--利用Statistics
set statistics time on select * from dbo.DatabaseLog set statistics time off
原文：http://www.cnblogs.com/hhhh2010/p/5463783.html