A rollback transaction executed in a trigger causes rollback of the insert, update, or delete statement that fired the trigger, along with any work performed by the trigger.
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.