rowcount « System Settings « SQL Server / T-SQL Tutorial

26.27.1.Using the SET ROWCOUNT Option
26.27.2.Updating an end user's expiration date.
26.27.3.adds the account column to the authors table and creates the new bank and brokerage tables.
26.27.4.if @@ROWCOUNT = 0, return
26.27.5.if @@ROWCOUNT > 1, rollback
26.27.6.@@rowcount can be used to verify the success of selected operations
26.27.7.EXEC and @@ROWCOUNT