Answer D is correct. You can use an INSTEAD OF TRigger to perform a different action than what was originally intended. INSTEAD OF TRiggers are executed in place of the usual triggering action. INSTEAD OF TRiggers can also be defined on views with one or more base tables, where they can extend the types of updates a view can support. For more information, see the following sources:
|