What does the INSTEAD OF trigger do?

Answer Posted / s.vanitha

The INSTEAD OF triggers execute instead
of the original data modification. INSTEAD OF trigger are
allowed for both tables and views.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to rebuild indexes with alter index ... Rebuild?

584


What are exact numeric data types in ms sql server?

508


Tell me what is difference between view and materialized view?

518


Give an example of SQL injection attack ?

568


What are statistics?

566






What is a benefit of using an after insert trigger over using a before insert trigger?

507


Explain how many normalization forms?

575


What is full outer join in sql server joins?

563


What are distinctive joins find as a part of sql?

554


What is 'write-ahead log' in sql server 2000 ?

625


What is equi join with example?

551


What is temporal table?

475


What is difference between after and before?

499


What is constraints and its types?

496


How to set a database state to offline in ms sql server?

534