SET NOCOUNT ON
Advantages of SET NOCOUNT ON – SQL Statement are
- (It prevents the sending of after process messages to the clients for each of SQL DML or DDL statements executed in a stored procedure. Actually stored procedures that contain several statements that do not return much actual data, Hence setting above SQL statement to ON can boost the performance as well as Network traffic between clients machines and Server is greatly reduced
- It will reduce another query to get the how many tables / records are updated once the SQL DML / DDL statements are executed. It will help us to boost the performance of the SQL server also
