How can we know how many rows are deleted from table

• SreenivasaRao

  SSC-Addicted

  Points: 499

  More actions

  August 9, 2005 at 5:07 am

  #94401

  Hi all

  How can we know how many rows are deleted from table?

  (for example we use delete from tablename, in this case i want to

  know how many rows deleted from table, is this possible or not?)

• venku009

  Mr or Mrs. 500

  Points: 503

  More actions

  August 9, 2005 at 5:26 am

  #580645

  Use @@RowCount

  @@RowCount returns the number of rows affected by the last statement.

  Extract from SQL Server Books Online

  This example executes UPDATE and uses @@ROWCOUNT to detect if any rows were changed.

  UPDATE authors SET au_lname = 'Jones'WHERE au_id = '999-888-7777'IF @@ROWCOUNT = 0   print 'Warning: No rows were updated'