SQL Error checking in xact
SQL
Download (.zip)
USE PUBS BEGIN TRAN UPDATE authors SET state = 'FL' WHERE state = 'KS'
IF @@ERROR <> 0 BEGIN ROLLBACK TRAN GOTO ON_ERROR END UPDATE jobs SET min_lvl = min_lvl - 10 IF @@ERROR <> 0 BEGIN ROLLBACK TRAN GOTO ON_ERROR END
COMMIT TRAN ON_ERROR:
SELECT * FROM authors WHERE state = 'FL'
|