How many types of TRIGGERS are there in MS SQL Server?
Answers were Sorted based on User's Feedback
Answer / swetha
There are 2 types of triggers
Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.
After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.
Is This Answer Correct ? | 68 Yes | 13 No |
Answer / anand
3 types of triggers
FOR/AFTER
I)DML Triggers
II)DDL triggers -introduces in SQL Server 2005
Instead OF triggers
LOGON Triggers -introduces in SQL Server 2005
DDL and LOGON are used to administrator related tasks
Is This Answer Correct ? | 33 Yes | 8 No |
Answer / yugal
SQL Server 2008 includes three general types of triggers:
1)DML triggers
2)DDL triggers
3)Logon triggers.
Is This Answer Correct ? | 26 Yes | 5 No |
Answer / devipriyanka
Types of Triggers
* DML(data manipulation language) triggers (SQL Server
2000- 80.0)
o AFTER triggers (Only Tables)
o INSTEAD OF triggers (Tables or Views)
* DDL(data definition language) triggers (SQL Server
2005- 90.0)
* SQLCLR triggers (SQL Server 2005- 90.0)
Is This Answer Correct ? | 13 Yes | 4 No |
Answer / balaji
which one is correct?
ISthis DML,DDL,CLR or Instead of trigger, after trigger
Is This Answer Correct ? | 15 Yes | 9 No |
Answer / rajkumar v
SQLserver2000
There are 2 types of triggers
Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.
After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.
SQLserver2005
3 types:
1. DML,
2. DDL &
3. CLR
Is This Answer Correct ? | 10 Yes | 4 No |
How to get the definition of a trigger back?
Do you know what are the restrictions that views have to follow?
What is the bookmark lookup and rid lookup?
What happens on checkpoint?
Do you know what are the reporting services components?
How to create a simple stored procedure in ms sql server?
When we can say that is in BCNF?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is sql server schema compare? How we can compare two database schemas?
How to get the definition of a stored procedure back?
How to update multiple rows with one update statement in ms sql server?
You are doing log shipping due to some reasons it is failing. How you will proceed from there