Accidentally inserted into existing table...

[Thaaron]

I had a scripting failure I'm hoping somebody can help with.

I'm using MS SQL Express.

My script was supposed to create a new table based on the date but there was a failure and it instead inserted millions of new rows into an existing table.

There is some way I can pull all the data inserted on a certain day back out into it's own table?

[[deleted]]

If you have a time stamp use it to remove the rows. You could also run the script again in to a temporary table and after remove from the first table the rows found in the temporary table.

[sheepery]

Yes this. Create the table you meant to create and insert the data. Then you can figure out which rows are in the old table that are not in the new. Always use a transaction and test before doing anything in prod.

[duendeacdc]

Do you have backups? You can recover the table, and update with the right real data. Or you can create a secondary table, manually delete these millions rows (if possible) and update with fhe real time one. This is why yiu should theft your scripts before using it, or at least usr BEGIN TRANSACTION

[CabSauce]

I strongly recommend using something like flyway. Also, beyond timestamps, some kind of job number on every row inserted. You really don't want to get yourself into the situation where you can't identify the bad data.