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