Only in the case of transaction based tables in which you haven't
committed;
Time to restore a backup.
"David S. Jackson" wrote:
>
> Hi,
>
> I did a really dumb thing. I went
>
> update Tablename set Name = 'Joe Bloe'
>
> instead of
>
> update Tablename set Name = 'Joe Bloe' where ID = 5
Hi,
I did a really dumb thing. I went
update Tablename set Name = 'Joe Bloe'
instead of
update Tablename set Name = 'Joe Bloe' where ID = 5.
Now all the Name records in Tablename = 'Joe Blow'
Damn. I can't believe I did that, but it was a slip of the hand.
Is there any easy way to recover
