Select from following answers:- INSTEAD OF triggers fire in place of the triggering action and before constraints are processed
- If there are AFTER triggers on the table, they will fire after constraint processing.
- If the constraints are violated, the AFTER trigger is not executed
- All Above
The INSTEAD OF triggers:
INSTEAD OF triggers can be defined on either tables or views; however, INSTEAD OF triggers are most useful for extending the types of updates a view can support. For example, INSTEAD OF triggers can provide the logic to modify multiple base tables through a view or to modify base tables that contain the following columns:
timestamp data type
Computed columns
Identity columns
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator