Only if the WHEN clause evaluates to true will the action part of trigger statement be executed.
仅当when子句的计算结果为真时，触发器语句的操作部分才会执行。
In addition, triggers can now contain UPDATE, DELETE, and INSERT operations together in a single clause as the trigger event. For example.
另外，触发器现在可以在单一子句中同时包含UPDATE、DELETE和INSERT操作，作为一个触发器事件。
Create the trigger (add checking for the global variable in the WHEN clause).
创建触发器(在when子句中添加对全局变量的检查)。
If so, it skips the validation process by using the WHEN clause in the trigger body.
如果已经执行了验证，那么在触发器代码体中使用when子句跳过验证过程。
The following example demonstrates the use of the WHEN clause in the trigger.
下面的例子演示了在触发器中使用WHEN 子句。
The WHEN clause of the trigger can be used to check if the new value is validated or not validated according to any of the specified schemas.
触发器的when子句可以用来检查是否根据任何指定模式对新值进行了验证。
REFERENCING clause: This clause can be used to define a trigger routine for a table object whose for EACH ROW actions can invoke the trigger routine.
REFERENCING clause：该子句为表对象定义触发器例程，这些表对象的FOR EACH ROW操作必须能够调用触发器例程。
Similar to the before trigger, the IS VALIDATED ACCORDING TO XMLSCHEMA clause can be used in the check constraints to enforce the validation.
与beforetrigger类似，可以在检查约束中使用ISVALIDATEDACCORDINGTO XMLSCHEMA 子句来加强验证。
Simultaneously, it expounds the minimum clause which is considered to be one of the main reasons that trigger off the disputes over trust contract in conducting financial transactions.
同时对引发委托理财合同纠纷的主要原因之一的保底条款进行较为详尽的阐析。
Huge doubts have been cast over Owen's future with the confirmation that he can trigger a 9 million buy-out clause in his contract following the Magpies' failure to qualify for Europe.
在喜鹊进军欧洲失败后，千千万万个疑问压到了欧文身上，由于他的合同上有900万英镑的买断费，大家都质疑他会不会下赛季离开纽卡。
Huge doubts have been cast over Owen's future with the confirmation that he can trigger a 9 million buy-out clause in his contract following the Magpies' failure to qualify for Europe.
在喜鹊进军欧洲失败后，千千万万个疑问压到了欧文身上，由于他的合同上有900万英镑的买断费，大家都质疑他会不会下赛季离开纽卡。
应用推荐