Answer
There are
three
types of
t
riggers.
(For a complete lesson on
Triggers see Chapters 2 and 3 of SQL Programming Joes 2 Pros
Volume 4 ISBN: 1451579489)
1)
DML
t
rigger
There are two
kinds
of DML
t
riggers
a.
Instead of Trigger
Instead of Trigger
s
ar
e fired in place of the
triggering action such as an insert, update, or
delete.
b.
After Trigger
After triggers execute following the triggering
action, such as an insert, update, or delete.
2)
DDL
t
rigger
This type of trigger is
fired against
DDL statements like
Drop Table, Create Table,
or
Alter Table. DDL Triggers are
always
a
fter Triggers.
3)
Logon
t
rigger
This type of trigger is fired against
a LOGON event before a
user session is established to the SQL Server
All sql Questions
Ask your interview questions on sql
Write Your comment or Questions if you want the answers on sql from sql Experts