|
What are triggers in SQL Server? - Triggers are special kind of event driven stored procedures.
- Executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table,
- Can specify which trigger fires first or fires last using sp_settriggerorder,
- Triggers can't be invoked on demand,
- They get triggered only when an associated action (INSERT, UPDATE, DELETE) happens,
- Triggers are generally used to implement business rules, auditing,
- Triggers can also be used to extend the referential integrity checks
|
