SQL transaction rollback operation with case analysis

SET Xact_abort on
BEGIN TRAN
INSERT into [pda_action] VALUES (' Purchase inbound 1 ')
INSERT into [pda_action] VALUES (' Purchase inbound 2 ')
SELECT 1/0/* Divisor is 0 error */
INSERT into [pda_action] VALUES (' Purchase inbound 3 ')
INSERT into [pda_action] VALUES (' Purchase inbound 4 ')
COMMIT TRAN

For a rollback of a statement with SELECT, use the following

Begin Try
Begin Tran Tran1
INSERT into [pda_action] VALUES (' Purchase inbound 1 ')
INSERT into [pda_action] VALUES (' Purchase inbound 2 ')
SELECT 1/0/* Divisor is 0 error */
INSERT into [pda_action] VALUES (' Purchase inbound 3 ')
INSERT into [pda_action] VALUES (' Purchase inbound 4 ')
COMMIT TRAN Tran1
END Try
Begin Catch
ROLLBACK TRAN Tran1 call rollback after error---
--select 0
END Catch

SQL transaction rollback operation with case analysis