Trigger preventing insert
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.
It will happen when there is an exception in the trigger (when an error happens in a trigger the batch is aborted).
精彩评论