Re: SQL UPDATE Query - 04-07-2010 , 04:11 PM
On Wed, 31 Mar 2010 11:26:04 -0700, Marc Noon wrote:
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