BEGIN TRANSACTION; -- Withdraw $100 from Account A UPDATE BankAccounts SET Balance = Balance - 100 WHERE AccountID = 1; -- An error occurs or the transaction is canceled ROLLBACK;