Export (0) Print
Expand All
8 out of 13 rated this helpful - Rate this topic

DML Triggers

A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. DML events include UPDATE, INSERT, or DELETE statements issued against a table or view. DML triggers are used to enforce business rules when data is modified and to extend the integrity checking logic of Microsoft SQL Server 2005 constraints, defaults, and rules.

This section provides the information necessary to understand, design, and implement DML triggers.

Topic Description

Understanding DML Triggers

Explains DML trigger concepts and includes descriptions and examples of when to implement DML triggers.

Designing DML Triggers

Provides specific guidelines, rules, and restrictions you should consider when designing a DML trigger.

Implementing DML Triggers

Describes the procedures to create, modify, or delete a DML trigger.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.