SQL Server transaction and exception handling examples

Begin transaction--Start Transaction

DECLARE @errorSun INT--Define error counters
SET @errorSun = 0--yes, 0.

UPDATE dbo. Test SET testname= ' 232 '
WHERE testid=1--transaction operation SQL statement
SET @[email Protected][email protected] @ERROR--whether the accumulation is wrong

--waitfor delay ' 0:2:0 '--Delay 2 minutes

UPDATE dbo. Testcustorm SET testnickname1= ' Nick232 '
WHERE testid=1--transaction operation SQL statement
SET @[email Protected][email protected] @ERROR--whether the accumulation is wrong

IF @errorSun <>0
BEGIN
PRINT ' ERROR, rollback '
ROLLBACK transaction--Transaction ROLLBACK statement
END
ELSE
BEGIN
PRINT ' success, submit '
Commit transaction--Transaction COMMIT statement
END

SQL Server transaction and exception handling examples