What are INSTEAD OF triggers used for?
To run non-database operations that are coded in user-defined functions.
To update data in other tables.
To perform insert, update, and delete operations against complex views.
To check or modify values before they are actually stored in a database.