Advertisement

Triggers

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

Abstract

SQL Server provides triggers as a means of executing T-SQL code in response to database object, database, and server events. SQL Server 2012 implements three types of triggers: classic T-SQL Data Manipulation Language (DML) triggers, which fire in response to INSERT, UPDATE, and DELETE events against tables; Data Definition Language (DDL) triggers, which fire in response to CREATE, ALTER, and DROP statements; and logon triggers, which fire in response to LOGON events. DDL triggers can also fire in response to some system SPs that perform DDL-like operations.

Keywords

Virtual Table Data Definition Language Data Manipulation Language Constra Ints 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles 2012

Authors and Affiliations

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

There are no affiliations available

Personalised recommendations