Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between after trigger and
instead trigger.
- 2 Answers
- 19797 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 is the difference between delete and truncate statements?
Define left outer join?
Can you tell me some of the common replication dmv's and their use? : sql server replication
How many types of attribute relationships are there? : sql server analysis services, ssas
What are the difference between clustered and a non-clustered index?
Which tools are available to manage SQL Azure databases and servers?
What is the maximum row of a size?
What is the optimization being performed in oracle and SQL Server?
Explain the categories of stored procedure?
What is merge?
Explain the collation?
What is change data capture (cdc) in sql server 2008?
What are the methods used to protect against sql injection attack?
What triggers long term care?
Explain the usage of floor function in sql server.
