SET NOCOUNT

SET NOCOUNT { ON | OFF } 

Permissions

SET NOCOUNT permissions default to all users.



When we use SELECT and DML statement in SQL. SQL SERVER return a message which specify the number
of rows affected by these statements. This information helps developer when they are debugging the
code other-wise this is not useful. We can disable this by typing SET NOCOUNT ON.
 Setting SET NOCOUNT ON for stored procedure contains lots of statements, loops increases the performance
and boost network traffic.

Thanks

Alok Kumar Sharma