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.