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?
August 1, 2019 at 8:16 pm
#3668044
found it.
delete from table output deleted.*
Steve Jones - SSC Editor
SSC Guru
Points: 728164
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
Follow me on Twitter: http://www.twitter.com/way0utwestForum Etiquette: How to post data/code on a forum to get the best helpMy Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply