declare @num datetime
select @num=getdate()
---------处理过程---------------
select * from tablename
---------处理过程---------------
select datediff(second,@num,getdate()) as '消耗时间(秒)'
select @num=getdate()
---------处理过程---------------
select * from tablename
---------处理过程---------------
select datediff(second,@num,getdate()) as '消耗时间(秒)'
select @num=getdate()
---------处理过程---------------
--select * from tablename
waitfor delay '00:00:10' --等待10秒 这样就更可以看出你用的时间
--select * from tablename
---------处理过程---------------
select datediff(second,@num,getdate()) as '消耗时间(秒)'