A trigger is a
special type of event driven stored procedure. It gets initiated when Insert,
Delete or Update
event occurs. It can
be used to maintain referential integrity. A trigger can call stored procedure.
Executed
automatically when an INSERT, UPDATE or DELETE operation takes place on a
table.
You 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
No comments:
Post a Comment