Lesson 11
IDENTITY
Is an auto-incrementing number. When a row is added, it increments by 1 and stores the data in the column with the IDENTITY data type.
Data Definition Language (DDL) Triggers
Is invoked in response to CREATE, ALTER, and DROP statements. A DDL trigger will also automatically be invoked in response to some stored procedures that perform DDL-like operations.
INSTEAD OF
executes instead of the DML firing statement. It replaces the firing statement.
Inserted Table
is automatically created by a DML trigger.
AFTER Trigger
is executed after the DML firing statement ends.
FOR Trigger
is executed after the DML firing statement ends.
Data Manipulation Language (DML) Triggers
is invoked automatically in response to INSERT, UPDATE, and DELETE events designed for a table.
Logon Triggers
is invoked in response to LOGON events.
SET NONCOUNT
is used to suppress the "number of rows affected" message from being returned whenever a trigger is fired.
Query Batch
lines of code that are run or executed as a group. There can be several query batches together, and each is considered a separate SQL statement.
CHECK
A column constraint that limits the data in the column.
Trigger
A trigger is a special stored procedure that is executed automatically in response to a database event, action, or object.
ROLLBACK
The ROLLBACK command reverts (or goes back) to the last saved transaction(s).
Deleted Table
The deleted virtual table is automatically created by a DML trigger.