Wednesday, July 11, 2012

How can we remove Row affected message in SQL SERVER? like "8 rows affected."


In this post, I am going to discuss that how you can remove row affected message in SQL SERVER while you fire a query in SQL Server. You can able to do that using NOCOUNT keyword like :

set NOCOUNT on
select * from tblVideo
set NOCOUNT off

OutPut:




Enjoy Magic Tricks!

No comments:

Post a Comment