How can I rollback an UPDATE query in SQL server 2005?

rollback, sql, sql-server-2005, sql-update

Solution

begin transaction

// execute SQL code here

rollback transaction

If you've already executed the query and want to roll it back, unfortunately your only real option is to restore a database backup. If you're using Full backups, then you should be able to restore the database to a specific point in time.

Problem

How can I rollback an UPDATE query in SQL server 2005? I need to do this in SQL, not through code.

Original source