O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_9

9. Triggers

Dmitri Korotkevitch

(1)Tampa, Florida, USA

Triggers define the code that runs in response to specific events. There are three types of triggers available in SQL Server, as follows:

  1. DML triggers fire when data modification occurs. You can use DML triggers in cases where you need to enforce specific business rules during data modifications and the system does not have a dedicated data access tier implemented. You can think about audit-trail functional, which captures who changed the data in the table, as an example. When a system has multiple applications working with the database directly, an audit-trail implementation based on triggers ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required