Database - SQL Server 2000 - Discussion
Discussion Forum : SQL Server 2000 - General Questions (Q.No. 7)
7.
Which of the three possible types of triggers does SQL Server support?
Discussion:
2 comments Page 1 of 1.
Ajay said:
1 decade ago
INSTEAD OF and AFTER only? whats the purpose of both?
Tejaswi said:
2 years ago
Types of SQL Server Triggers:
1. DDL Triggers
2. DML Triggers
3. Logon Triggers.
DDL Triggers are responses to DDL events like CREATE, ALTER, and DROP.
DML Triggers are responses to DML events like INSERT, UPDATE, and DELETE.
They are of 2 types:
(i) AFTER Triggers: which are trigged after the transaction is completed.
(ii) INSTEAD OF triggers: which are trigged before the transaction is completed. It is executed even if the transaction fails.
LOGON Triggers are responses to LOGON events.
These events are created after a successful user authentication process of logging in.
1. DDL Triggers
2. DML Triggers
3. Logon Triggers.
DDL Triggers are responses to DDL events like CREATE, ALTER, and DROP.
DML Triggers are responses to DML events like INSERT, UPDATE, and DELETE.
They are of 2 types:
(i) AFTER Triggers: which are trigged after the transaction is completed.
(ii) INSTEAD OF triggers: which are trigged before the transaction is completed. It is executed even if the transaction fails.
LOGON Triggers are responses to LOGON events.
These events are created after a successful user authentication process of logging in.
(1)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers