@@ROWCOUNT returns the number of rows affected by the last statement. Returns the number of rows affected by the last statement. If the number of rows is more than 2 ...
Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in a future release of SQL Server. Avoid using SET ROWCOUNT with DELETE, INSERT, and UPDATE statements in new development work, ...