Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between after trigger and
instead trigger.
- 2 Answers
- 19895 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
Explain various data region available in ssrs with their use?
Please differentiate between a local and a global temporary table?
What is the optimization being performed in oracle and SQL Server?
Define Joins?
What is the downside of using udf?
What is self contained scalar sub query?
How to test values returned by a subquery with the in operator?
Explain the Ways to improve the performance of a sql azure database?
What happens on checkpoint?
What is data source view or dsv? : sql server analysis services, ssas
What is the use of commit?
How real and float literal values are rounded?
What is an execution plan? How would you view the execution plan?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Can you index views?
