what is the main difference between after trigger and
instead trigger.
- 2 Answers
- 19269 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
What are different types of replication in sql server?
What is coalesce in sql server?
How to get nth highest salary from employee table.
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What functions can a view be used to performed?
What are data driven subscriptions?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Can group functions be used in the order by clause in ms sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is an execution plan?
How do I edit a stored procedure in sql server?
Working with TLogs
What is full outer join in sql server joins?
What is a data collection table?
How to use subqueries with the in operators in ms sql server?
