Using @@ROWCOUNT can be a bit tricky

(Kenneth Fisher) @@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently used in loops and in error handling.

Read More - Register for Free Membership