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
Define Unique Key?
How to drop an existing table?
What is the difference between online clustering and Offline clustering?
How do I debug a stored procedure in sql server?
How to populate a table in sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is difference between delete & truncate commands?
Define views.
What is 2nf normalization?
What is query processing?
What are the various editions of sql server 2017 that are available in the market?
Write a sql query to get zero records from a table having n number of records?
What is an expression in ms sql server?
What is database architecture? : SQL Server Architecture
What is a performance monitor?