A trigger is a database object that is bound to a table. It is similar to a stored procedure.Triggers are often referred to as a "special kind of stored procedure".
Where we Use Triggers ?
There are many reasons to use triggers. To avoid unnecessary delete in the table.Also used to log the table details.If you want to do other stuff while in progress.
Tables can have multiple triggers. The CREATE TRIGGER statement can be defined with the FOR UPDATE, FOR INSERT, or FOR DELETE clauses to target a trigger to a specific class of data modification actions. When FOR UPDATE is specified, the IF UPDATE (column_name) clause can be used to target a trigger to updates affecting a particular column.
SQL Server 2000 greatly enhances trigger functionality, extending the capabilities of the triggers you already know and love, and adding a whole new type of trigger, the "Instead Of" trigger.
SQL Server 2000 has many types of triggers:
- After Trigger
- Multiple After Triggers
- Instead Of Triggers
- Mixing Triggers Type
No comments:
Post a Comment