Transactions

Group changes into a transaction so they all happen or none do, and use ROLLBACK as a safety net while you work.

Updated

Cheat sheet: Transactions
Category
SQL
Level
Apprentice
Tags
ACID Properties, BEGIN TRANSACTION, COMMIT (database), ROLLBACK (database), sql, Transaction, TRY...CATCH, t-sql