不如去下载一个分析工具了。 比如 Toad.for.SQL.Server quest central for databases 等http://www.500wan.com/Info/ssq/datachart/redzoushi.shtml TOAD for SQL SERVER下载地址 http://lib.verycd.com/2006/01/06/0000083469.html http://lib.verycd.com/2006/09/27/0000121547.html 牛皮糖软件有下的.3.0版,我下了,有key,很好用,for sql server 2005
比如
Toad.for.SQL.Server
quest central for databases
等http://www.500wan.com/Info/ssq/datachart/redzoushi.shtml TOAD for SQL SERVER下载地址
http://lib.verycd.com/2006/01/06/0000083469.html
http://lib.verycd.com/2006/09/27/0000121547.html
牛皮糖软件有下的.3.0版,我下了,有key,很好用,for sql server 2005
set @s1=getdate()
exec proc1
select @t1=datediff(ms,@s1,getdate())set @s1=getdate()
exec proc2
select @t2=datediff(ms,@s1,getdate())select @t2-@t1