How many types of TRIGGERS are there in MS SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
What is rolap and its advantage? : sql server analysis services, ssas
What are translations and its use? : sql server analysis services, ssas
What are the disadvantages of using the stored procedures?
How to filter records of table in SQL SERVER?
What is the need for indexing?
What is normalization and denormalization in sql server?
What is mean by candidate key?
How can I add Reporting Services reports to my application?
Define msdb database?
What is molap and its advantage? : sql server analysis services, ssas
What are scalar functions in sql?
What happens if we shrink log file in sql server?
Explain about integration services of Microsoft SQL server?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How to insert multiple rows with a subquery?