Rollback Help

[RR3]

I'm kind of new to SQL. Is there a way to undo something in a query. Like, I did an UPDATE and updated the entire database instead of using the WHERE statement.
Some things I found dealt with rollback, but it seems it might be too late for that.
Any help would be much appreciated.
revX

 

[fluteplr]

roll back only works within a transaction. At this point I would say you are stuck unless you have a backup you can revert to.

 

[RR3]

Thaks for the help. I new I was screwed.