SQL Server > Transact-SQL > SET NOCOUNT
Stops the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results.
SET NOCOUNT { ON | OFF }
Remarks
- ON the count is not returned
- OFF the count is returned