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

If you have any doubts, please let me know

PARASHURAMA JAYANTI 2020

In year 2020, Parashurama Jayanti will Celebrate on Saturday, 25th April 2020. Parashurama Jayanti Muhurat : Parashurama J...