SQL Server comprehensive tutorial-triggers (Reading Notes)

P279
Trigger, special stored procedure.
When an event is triggered, such as update, insert, or delete,
Automatic execution can achieve complex referential integrity that cannot be guaranteed by the primary key and foreign key.
A trigger that can call a stored procedure.
After trigger and instead of trigger.
After is completed by the system process sp_settriggerorder.
Instead of only executes the trigger itself.
First trigger
Create trigger trg_di_table
On Table
For Delete, update
As SQL _statements
Return
P284 principle, further research.