How to cancel a completed update request?

Question

SQL Server

Request completed, updated the wrong fields.

Answer 1

All changes are in the log ( LDF).

The LDF file contains enough information to revert or undo changes, or even restore the database to a specific point in time.

For example .

Answer 2

ROLLBACK

Answer 3

Most often, Borjomi is too late to drink.
Well, you can find out which recovery mode is set
SELECT name,recovery_model_desc FROM sys.databases
and congratulate yourself on moving into the second category of three:
1. People who do not make backups yet
2. People who already do backups
3. People who already check the backups they have made.
In general, on a working database, any update should begin with BEGIN TRANSACTION