Is there a simple and effective way to revert an update query after the fact?
--
-M Noon

On Wed, 31 Mar 2010 11:26:04 -0700, Marc Noon wrote:

If you started a transaction before the UPDATE, you can issue a ROLLBACK
TRANSACTION statement. If the transaction was started longer ago, this
will undo all work done in the transaction.

If you were already in a transaction but took a savepoint just before
the UPDATE, you can use ROLLBACK plus the savepoint name to undo just
the update and keep the rest of the transaction.

If you had no transaction or if it's already committed, restoring from
backup is your only hope.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis