sqlserver执行时间和自行效率 

SET STATISTICS PROFILE ON 
--SET STATISTICS IO ON 
--SET STATISTICS TIME ON



declare @dtm datetime
SQL语句

print '添加person临时表数据:'+convert(varchar(10),DATEDIFF(ms,@dtm,getdate())) 
select @dtm=GETDATE()

SQL语句

print '添加person临时表数据:'+convert(varchar(10),DATEDIFF(ms,@dtm,getdate())) 
select @dtm=GETDATE()



SET STATISTICS PROFILE OFF
--SET STATISTICS IO OFF
--SET STATISTICS TIME OFF

　　

 

posted @ 2014-08-09 10:40  kuailewangzi1212  阅读(265)  评论(0)  编辑  收藏  举报