Answer Posted / vani
Instead of triggers are the procedures that execute in
place of Data Manipulation language (DML)statement on a
table.
for example, if i have INSTEAD-OF-UPDATE Trigger on
TableA,and i execute an update statement on that table,the
code in the INSTEAD-OF-TRIGGER will be executed instead of
the update statement that I executed.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the order by used for?
Explain different types of collation sensitivity?
How many types of functions are there in sql server?
How sql server enhances scalability of the database system?
What is subquery in sql?
What are the steps you should follow to start sql server in single-user mode?
What is the difference between Triggers and Stored Procedure?
What is deploy, process and build? : sql server analysis services, ssas
Why use “pivot” in sql server?
Scalability, Availability, Integration with internet, etc.)?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How would you go about developing a ssrs report?
Explain the third normal form(3nf)?
Is there any difference between primary key and unique with the not null condition?
Explain about service Broker functions?