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