Number of rows affected by query.

Question

How do you get the number of rows affected by query?

Vulpes · Answer

In SQL Server you can use @@ROWCOUNT. See http://technet.microsoft.com/en-us/library/ms187316.aspx