Difference between After and Instead Of Triggers in SQL Server Tamil

แชร์
ฝัง
  • เผยแพร่เมื่อ 7 เม.ย. 2017
  • Click here to Subscribe to IT PORT Channel : / @itport28
    After Triggers fire after the execution of an action query that can be either DDL statements like Create, Alter and Drop or DML statements like Insert, Update and Delete
    Instead OF Triggers fire before the execution of an action query that can only be DML statements like Insert, Update and Delete but after the execution of that query. The table data will not be affected, in other words if you want to insert or update the data of the table then you need to write it in the trigger using "inserted" or "deleted" virtual tables
    Explained in Tamil
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 1