Wednesday, July 11, 2012

How can we display the time for multiple queries in SQL SERVER?


In this post, you can able to display the time of multiple queries in SQL SERVER. 

set statistics time on 
select * from tblVideo 
select * from tblNews 
set statistics time off 

 Within Results Tab, you can able to see set of records like : 


 OutPut: Within Messages Tab, you can able to see time for multiple queries like : 


 Enjoy it! :-)

No comments:

Post a Comment