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 are the Advantages of using CTE in sql server?
List the different types of joins?
What happens if strings are casted into wrong code pages in ms sql server?
Does the order of columns in update statements matter?
What is 1nf 2nf?
Can coalesce return null?
What the difference between UNION and UNIONALL?
What is the difference between having clause and where clause in sql server?
What is a non equi join?
How to get the definition of a view out of the sql server?
How to loop through returning rows?
What happens if date-only values are provided as date and time literals?
Can we use where clause in union?
Do you know how to make remote connection in database?
If a table does not have a unique index, can a cursor be opened on it?