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触发器和包含SQLPL复合语句的触发器。
Now you can handle data version management and effective tracking of business events using this technique instead of application-level triggers and stored procedures.
现在您可以使用此技术处理数据版本管理和业务事件的有效跟踪,而无需使用应用程序级的触发器和存储过程。
That means, every single time those triggers come up, do the positive habit you identified instead of the negative one.
具体来说,就是每当诱因出现时,用你已经找到的积极的习惯来代替消极的。
Instead they found that punishment often triggers a spiral of retaliation, making it detrimental and destructive rather than beneficial.
他们发现惩罚反而往往会引发相互之间愈发激烈的报复,这比互相给好处来得更有害,也更具破坏性。
Same process, just a different trigger. Instead of this hunger signal coming from our stomach, this emotional signal — feeling sad — triggers that urge to eat.
同样的过程,只是用不一样的触发方式来代替原本我们胃里的饥饿讯息,这种情感上的讯息息——感到伤心——触发了想吃的冲动。
For example, instead of a player action triggering an effect such as a sound effect, perhaps it triggers a specific creature AI patrolling pattern.
例如,用玩家的动作触发一个特殊AI人物的巡逻模式来代替触发一个音效。
For example, instead of a player action triggering an effect such as a sound effect, perhaps it triggers a specific creature AI patrolling pattern.
例如,用玩家的动作触发一个特殊AI人物的巡逻模式来代替触发一个音效。
应用推荐