1.

What Are Triggers? Why Do We Use Them? Diff Types Of Triggers? What Are Magic Tables?

Answer»

A trigger is a stored procedure BOUND to a table, which is implicitly executed when a user attempts to modify DATA with an insert, delete, or update command.
Use :  i. Validation PURPOSE
ii.Referential integrity
Type of trigger: –
i. update
ii. delete
iii.insert
Two tables are created at the time of trigger execution
1. INSERTED
2. Deleted which are called magic tables.

A trigger is a stored procedure bound to a table, which is implicitly executed when a user attempts to modify data with an insert, delete, or update command.
Use :  i. Validation purpose
ii.Referential integrity
Type of trigger: –
i. update
ii. delete
iii.insert
Two tables are created at the time of trigger execution
1. Inserted
2. Deleted which are called magic tables.


Discussion

No Comment Found

Related InterviewSolutions