How many types of TRIGGERS are there in MS SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How can we rewrite sub-queries into simple select statements or with joins?
What are a database and a data warehouse?
Explain about Joins?
How to download and install microsoft sql server management studio express?
How to see the event list of an existing trigger using sys.trigger_events?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What are the drawbacks of reporting in ssrs?
How to change server name in sql server?
What are different types of table joins?
What is a recursive stored procedure in sql server?
What is an sql server agent?
Mention what are the different types of ssrs reports?
What is cube dimension? : sql server analysis services, ssas
What is the use of builtinadministrators group in sql server? : sql server security