what is the main difference between after trigger and
instead trigger.
- 2 Answers
- 18871 Views
- I also Faced
- E-Mail Answers
Answer Posted / durga prasad
After Trigger fires an operation after any
insert,update,delete operations performed on a table.
Instead Of Trigger fires an operation instead of performing
user specified operation.
u can create instead of trigger on views but u can not
create after triggers on views
| Is This Answer Correct ? | 38 Yes | 5 No |
Post New Answer View All Answers
How many null values we can have in a unique key field in sql server?
How to override dml statements with triggers?
Can you roll back the ddl statement in a trigger?
What is sql server schema compare? How we can compare two database schemas?
What is sql server database?
What is after dml trigger?
Explain the working of sql privileges?
Explain how to use linked server?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to define and use table alias names in ms sql server?
What happens to a trigger with multiple affected rows?
Can the query output be sorted by multiple columns in ms sql server?
What are the Advantages of using CTE in sql server?
Is the log file is a part of file group?
Explain filtered indexes benefits?
