Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Are the Insert operation and Trigger associated with it are collectively atomic in nature ?

So the scenario is there is a table name tbl_A and we have a trigger associated with insertion of tbl_A Will DBMS make sure that upon insertion the tbl_A the table remain lock for further insertion until the insert trigger get executed? Thanks,

user-image
Question added by Usman Khan , Cyber Security Specialist , DTS Solution
Date Posted: 2014/01/18
Mohammad  Faisal
by Mohammad Faisal , Data Analyst , Websart.in Ltd Delhi

These trigger ,which perform thier opertation inserted of performing user specified opretion.

Muhammad Arshad Gondal
by Muhammad Arshad Gondal , Daputy Manager IT , NOON SUGAR MILLS LIMITED

As i think DBMS execute insert then Trigger then next insert .