How many types of TRIGGERS are there in MS SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
What are the two modes of authentication in sql server?
How to how to convert numeric expression data types using the convert() function??
What is checkpoint in sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
What is read committed?
Which rendering formats are affected by the pagesize properties?
Explain about system database?
How do I view a script in sql server?
How to return the top 5 rows from a select query in ms sql server?
Explain external key management in sql server 2008
What is the difference between mysql and mysqli?
What are statistics?
What is rolap and its advantage? : sql server analysis services, ssas
Do you know what is a with(nolock)?
Difference between report and query parameter.