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 happens when transaction log is full?
How to check if stored procedure is running in sql server?
What is sql server transaction log file?
Can we use having clause without group by?
explain declarative management framework (dmf) in sql server 2008?
what is difference between NULL and ISNULL in SQL Server 2008?
What is resource db in sql server?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What are the types of resultset?
Explain the creation and execution of a user-defined function in the sql server?
What is bookmark link in ssrs?
What is transactional replication?
What stored procedure can you use to display the current processes?
What are different types of statements that are supported by sql?
Why would you call update statistics?