| When we are executing SELECT or DML statement the SQL server returns a message that provides number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON we are able to disable the feature of returning this extra information. But in store procedure this is not so usefull becuase it may contains several statements or contain Transact-SQL loops so by setting SET NOCOUNT to ON will provide a significant performance boost because network traffic is greatly reduced. | | |