set statistics time on select * from tb where set statistics time off
SET Statistics TIME ON GO declare @b datetime,@e datetime set @b =getdate() select * from tb set @e =getdate() select datediff(ms,@b,@e) SET Statistics IO OFF GO SET Statistics TIME OFF GO
1.set statistics time on 2.右下角也能看到啊 3.还有6楼水哥的办法~
SET Statistics TIME ON GO declare @b datetime,@e datetime set @b =getdate() select * from Server_Details set @e =getdate() select datediff(ms,@b,@e) SET Statistics IO OFF GO SET Statistics TIME OFF GO
set statistics time on
select * from tb where
set statistics time off
GO
declare @b datetime,@e datetime
set @b =getdate()
select * from tb
set @e =getdate()
select datediff(ms,@b,@e)
SET Statistics IO OFF
GO
SET Statistics TIME OFF
GO
2.右下角也能看到啊
3.还有6楼水哥的办法~
SET Statistics TIME ON
GO
declare @b datetime,@e datetime
set @b =getdate()
select * from Server_Details
set @e =getdate()
select datediff(ms,@b,@e)
SET Statistics IO OFF
GO
SET Statistics TIME OFF
GO
如果时间小于 1 秒在 右下角是显示不出来的了[/align]