TSQL Transaction Management

TransactionManagement.sql

DECLARE @ERRORCODE INT

BEGIN TRANSACTION

-- do action

-- check for errors after each transaction if desired
SELECT @ERRORCODE = @@ERROR
IF (@ERRORCODE <> 0) GOTO PROBLEM

-- last statement before Problem resolution
COMMIT TRANSACTION

PROBLEM:
IF(@ERRORCODE <> 0 ) BEGIN
    ROLLBACK TRANSACTION
	
    -- Raise an error and return
    RAISERROR ('Put your error response here', 16, 1)
    RETURN
END