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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles
About this chapter
Cite this chapter
Natarajan, J., Bruchez, R., Shaw, S., Coles, M. (2012). Triggers. In: Pro T-SQL 2012 Programmer’s Guide. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4597-1_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4597-1_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4596-4
Online ISBN: 978-1-4302-4597-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books