Anzeige
Erschienen in:
2015 | OriginalPaper | Buchkapitel
7. Triggers
verfasst von : Miguel Cebollero, Jay Natarajan, Michael Coles
Erschienen in: Pro T-SQL Programmer's Guide
Verlag: Apress
Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.
Wählen Sie Textabschnitte aus um mit Künstlicher Intelligenz passenden Patente zu finden. powered by
Markieren Sie Textabschnitte, um KI-gestützt weitere passende Inhalte zu finden. powered by
Abstract
SQL Server provides triggers as a means of executing T-SQL code in response to database object, database, and server events. SQL Server 2014 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.