How do I revert a SQL update query?

Question

Add a transaction and try statement before and after the update statement. BEGIN TRY. BEGIN TRANSACTION. Select/update/delete. COMMIT TRANSACTION. END TRY. BEGIN CATCH. ROLLBACK TRANSACTION. -- Consider logging the error and then re-raise.

Can I undo an update query in SQL Server?

Right click on database -> Tasks -> Restore -> Database. In General tab, click on Timeline -> select Specific date and time option. Move the timeline slider to before update command time -> click OK.

How do I rollback a query in SQL Server?

In the below example, we do the following tasks.1Declare a table variable @Demo.2Insert a record into it.3Starts an explicit transaction using BEGIN TRANSACTION.4Update the record in the table variable.5Rollback transaction.6Check the value of the record in the table variable.

Can update be rolled back?

The short answer is: No. However, you don't have to take the DB offline to do a partial restore on a table or tables. You can restore a backup to a separate database and then use TSQL queries to restore the rows that were negatively impacted by your update. This can take place while the main database is online.

Expert · Answer