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

　　

 

转载于:https://www.cnblogs.com/kuailewangzi1212/p/3900675.html