Triggers

Question 0

Differences between triggers and stored procedures

Answer 0

Triggers are fired by an event like a tbl insert not called

They have the deleted (old row copy) and the inserted (new row copy) tbls available.

Triggers does not have I/o parameter option.

Triggers never return tbl like results.

Note: a downside to triggers when deleted its not easily detected compared to stores proc.

Question 1

Can be defined on these objects

Answer 1

Can be applied to:
Tables, dbases, servers (logon)

Table (DML)
View (DML, instead of trigger)
Database (DDL)
Server (DDL)

Question 2

Create trigger syntax

Answer 2

CREATE TRIGGER triggername ON 
fullyqualifiedtblname 
FOR INSERT, UPDATE AS
BEGIN
    UPDATE

Question 3

3 types of triggers

Answer 3

DDL - CREATE, ALTER, DROP
DML - INSERT, UPDATE, DELETE
Logon