ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Usman Khan , Cyber Security Specialist , DTS Solution
تاريخ النشر: 2014/01/18
Mohammad  Faisal
من قبل Mohammad Faisal , Data Analyst , Websart.in Ltd Delhi

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

Muhammad Arshad Gondal
من قبل Muhammad Arshad Gondal , Daputy Manager IT , NOON SUGAR MILLS LIMITED

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