How to reverse inserted values

Question

Hi I Insert Data in one table without using begin tran how do i reverse the values now.

Nitin Sontakke · Answer

I don't think there is any way in which a transaction which is once committed can be rolled back. All you have do is identify inserted records and then delete them with an appropriate WHERE clause.

Amit Gupta · Answer

Hey Snowal As nitin sir said you cannot rollback a transaction once it has committed. However you can save your data by restoring your backup files.