You might consider using INSTEAD OF triggers for interaction with views.
您也许可以考虑使用 INSTEAD OF 触发器来与视图交互。
You can now define multiple INSERT, DELETE, UPDATE, and SELECT triggers on a table and multiple INSTEAD OF triggers for the view.
现在可以在一个表上定义多个 INSERT、DELETE、UPDATE 和 SELECT 触发器,也可以在一个视图上定义多个 INSTEAD OF 触发器。
Supports before row triggers, after row and statement triggers, instead of triggers and triggers with SQL PL compound statements.
支持行前触发器、行后和语句触发器、instead of触发器和包含SQL PL复合语句的触发器。
应用推荐