Abstract
This chapter presents recipes for creating and using Data Manipulation Language (DML) and Data Definition Language (DDL) triggers. DML triggers respond to INSERT, UPDATE, and DELETE operations against tables and views. DDL triggers respond to server and database events such as CREATE TABLE and DROP TABLE statements.
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
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2012 Jason Brimhall
About this chapter
Cite this chapter
Brimhall, J., Dye, D., Gennick, J., Roberts, A., Sheffield, W. (2012). Triggers. In: SQL Server 2012 T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4201-7_19
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4201-7_19
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4200-0
Online ISBN: 978-1-4302-4201-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books