| |
| |
|
|
T-SQL Triggers
|
Enforcing Business Rules with Triggers - Microsoft SQL Server provides two primary mechanisms for enforcing business rules and
data integrity: constraints and triggers.
Exploring SQL Server Triggers - Triggers are one of the core tools
available in relational databases such as SQL Server 2000.
INSTEAD OF Triggers - INSTEAD OF triggers, which give you the
added benefit of being able to examine proposed changes to your data
before those changes take place. In addition, you'll see that you can
use INSTEAD OF triggers to update certain kinds of views that aren't
usually updateable.
Setting Limits with Triggers - Triggers are primarily being used to enforce business rules that can't be
enforced with check constraints.
Triggers - Microsoft SQL Server triggers are a special class of
stored procedure defined to execute automatically when an UPDATE,
INSERT, or DELETE statement is issued against a table or view.
Triggers are powerful tools that sites can use to enforce their
business rules automatically when data is modified.
|
|
|
|
|