S.No |
DML
Triggers
|
DDL
Triggers
|
1
|
Where
it operates ?
Operates
on INSERT, UPDATE and DELETE.
|
Where
it operates ?
Operates
on CREATE, DROP and ALTER.
|
2 |
Where
it can be applied ?
Applied
on Tables and views.
|
Where
it can be applied ?
Applied
on Databases and servers.
|
3 |
Whether
it can be used as INSTEAD OF TRIGGERS ?
Can
be used as INSTEAD OF TRIGGERS.
|
Whether
it can be used as INSTEAD OF TRIGGERS ?
Cannot
be used as INSTEAD OF TRIGGERS.
|
4 |
Whether
Magic tables can be created ?
Creates
INSERTED and DELETED tables.
|
Whether
Magic tables can be created ?
Cannot
create INSERTED and DELETED tables.
|
5 |
When
it runs ?
DML
triggers run either Before or After a T-SQL statement is
completed .
|
When
it runs ?
DDL
triggers run only after a T-SQL statement is completed .
|
No comments:
Post a Comment