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

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...