About set rowcount and @ rowcount

Code

Set rowcount 5
USE pubs
GO
Go
SELECT * FROM jobs
GO
If @ rowcount = 5
Print 'influencing row: '+ rtrim (@ rowcount)

About set rowcount

Setting the set rowcount option will stop most Transact-SQL statements after they are affected by a specified number of rows. This includes data modification statements such as triggers, INSERT, UPDATE, and DELETE. The ROWCOUNT option is invalid for dynamic cursors, But it limits the row set and does not perceive cursors of the key set. Exercise caution when using this option, which is mainly used with the SELECT statement.

@ Rowcount

Returns the number of rows affected by the previous statement.
Syntax: @ ROWCOUNT
Return type: integer
Note: any statement that does not return rows sets this variable to 0.