vendredi 26 février 2016

Undo "Update" statement in SQL Server 2005

I'm using SQL SERVER 2005 with FULL recovery model. I accidentally executed the UPDATE statement without specify the condition using WHERE clause.

UPDATE TABLE SET Column1='All'

Now all Column1 data are set to 'All'. And I need to undo the column1 to have previous data.

Any idea? Thanks...

Aucun commentaire:

Enregistrer un commentaire