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.