Using the ROW_COUNT Keyword

The ROW_COUNT keyword returns the number of rows the most recently executed DML statement processed. ROW_COUNT counts these rows:

• Inserted into a table
• Updated in a table
• Deleted from a table