Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Are there any plans to implement INSTEAD OF triggers for views?
An INSTED OF trigger is code that is executed instead of an INSERT, DELETE or UPDATE statement.
This works for both tables and views.
Syntax:
CREATE TRIGGER [schema_name.] trigger_name
ON
INSTEAD OF
{[INSERT] [,] [UPDATE] [,] [DELETE] }AS
{sql_statements}You can find some documentation about this at:
https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/
https://www.oracletutorial.com/plsql-tutorial/oracle-instead-of-triggers/