Transactional Behavior with Multiple Triggers

A rollback transaction executed in a trigger of the insert, update, or delete statement that fired the trigger, along with any work performed by the trigger to be rolled back.

For multiple triggers, a rollback transaction from one trigger also rolls back the work of other triggers already fired and withholds firing any remaining triggers for the current insert, update or delete command.