Reputation: 685
Is there any reason that having a trigger on a table would prevent the original insert statement from inserting? The trigger is run AFTER the row is inserted in the table, and there is no transaction rollback in the trigger.
Upvotes: 1
Views: 343
Reputation: 24125
It will happen when there is an exception in the trigger (when an error happens in a trigger the batch is aborted).
Upvotes: 3