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 secondary xml indexes?
What is user-defined functions? What are the types of user-defined functions that can be created?
When is the use of update_statistics command?
What is a database table?
In case you have filters in your report, when filters will be applied in cached report instance?
How to make conditional sum in ssrs?
Is oracle faster than sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What are different types of replication in sql server?
Explain multiserver query
Explain syntax for viewing trigger?
what is difference between NULL and ISNULL in SQL Server 2008?
Explain what is cte (common table expression)?
What is the Disadvantage of indexed sequential file.
When would you prefer to have a minimum number of indexes?
