Abstract
SQL Server provides triggers as a means of detecting database events and executing T-SQL code in response. SQL Server 2005 implements two types of triggers: classic T-SQL DML triggers that fire in response to INSERT, UPDATE, and DELETE statements, and new DDL triggers that fire in response to CREATE, ALTER, DROP, and some stored procedures 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
© 2007 Michael Coles
About this chapter
Cite this chapter
(2007). Triggers. In: Pro T-SQL 2005 Programmer’s Guide. Apress. https://doi.org/10.1007/978-1-4302-0387-2_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0387-2_7
Publisher Name: Apress
Print ISBN: 978-1-59059-794-1
Online ISBN: 978-1-4302-0387-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books