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;

See Also