From SSMS, how to see the deleted records in output window

• jdc

  Old Hand

  Points: 367

  More actions

  August 1, 2019 at 8:14 pm

  #3668043

  Hi

  I'm deleting rows from a table and I want to see them in output window. But I'm just getting like  (2834 row(s) affected).

  How to see the actual records it is deleted? Is this possible from SSMS?

• jdc

  Old Hand

  Points: 367

  More actions

  August 1, 2019 at 8:16 pm

  #3668044

  found it.

  delete from table output deleted.*

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  August 2, 2019 at 8:49 pm

  #3668397

  For others, use OUTPUT clause - https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-2017