SET NOCOUNT#
Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned as part of the result set.
Syntax#
SET NOCOUNT { ON | OFF } [;]
Remarks#
Argument values are ignored and do not change the default behavior.
Permissions#
Requires membership in the public role.
Examples#
SET NOCOUNT ON;