what is the main difference between after trigger and
instead trigger.
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 to remove duplicate rows from table?
What is amo? : sql server analysis services, ssas
Explain what you mean by 3 tier architecture.
How to get the query of a table in sql server?
What is a performance monitor?
Tell me about the approaches which you used to counter the DI problems.
What do you mean by stored techniques? How would we use it?
Explain what is row_number function?
What are the differences between DDL, DML and DCL in SQL?
What does it mean to invest in the index?
Explain transaction server implicit?
Do you know how to implement service broker?
When do you think a developer should use sql server-based cursors?
How to assign new column names in a view?
What is a field name?