I have inserted a significant quantity of records into a table. Unfortunately, these records should not have been inserted in this table. Deletion of the records in a one-by-one fashion is not feasible.
How can one rollback the aforementioned records in this situation?
Here are couple additional ideas you can try.
Restore a full backup in another database and then compare tables using some third party tools such as ApexSQL Data Diff or dbForge or Red Gate
If database was in full recovery mode try reading transaction log. Here are several posts on this topic:
SQL Server Transaction Log Explorer/Analyzer
Assuming you were not inside a transaction when you did this, you're going to find the process painful. Not sure what flavour of DBMS you're interested in, but here's some info on SQL Server 2005:
Rollback transaction using transaction log
Essentially, the easiest way to do this is to restore your DB from a backup that predates your inserts.
I am guessing the inserts statements have been committed to the database else you could simply do a ROLLBACK;
Do you have an audit table? If there is an audit table you would be able to identify the rows inserted during a particular datetime and then delete them...
Are there any features of the inserted rows that make them distinguishable from all of the others? For example is there an inserted date, or a numeric identity column? If so, just do a delete based on that criteria.
Other than that, butterchicken is right, it's probably a bit painful. But I've never rolled back using a transaction log like that before.
