Example:
DECLARE @Xtable TABLE(Col1 INT); INSERT INTO @Xtable (Col1) VALUES(1), (2), (3), (4), (5), (6), (7), (8), (9); SELECT * FROM @Xtable; SELECT @@ROWCOUNT AS [ROWCOUNT]; UPDATE @Xtable SET Col1 = 0 WHERE Col1 % 2 = 0; SELECT @@ROWCOUNT AS [ROWCOUNT]; SELECT * FROM @Xtable;