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;
