SET NOCOUNT

In Stored Procedur we usually see some words like SET NOCOUNT

The meaning of this...

Syntax

SET NOCOUNT { ON | OFF }

When SET NOCOUNT is ON, the count (indicating the number of rows affected by a Transact-SQL statement) is not returned.

When SET NOCOUNT is OFF, the count is returned. 

The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.