TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
然而,就在激活触发器之前,我们用IWH. EDITION和IWH . LOGMSGS中所包含的当前信息初始化了这些表的内容。
However, we initialize the content of these tables with the current information contained in the IWH.EDITION and IWH.LOGMSGS just before activating the triggers.
最后,我改变了用来激活对感兴趣的新方法的跟踪的触发器方法。
Finally, I changed the trigger method used to activate the trace to the new method of interest.
当一个指定的SQL操作(如DELETE,INSERT,或者是UPDATE操作)作用于某张表时,一个定义了一组操作的触发器就可以被激活。
When a specified SQL operation — a DELETE, INSERT, or UPDATE — occurs on a table, a trigger can be activated that defines a set of actions.
注意,您也许无法指定其中的一个correlationname,因为它依赖于引起触发器启动的特定操作和激活时间的组合。
Note that you might not be able to specify a correlation name for an option depending on the combination of activation time and the particular operation that causes the trigger to fire.
因此,在merge -insert操作过程中,仅激活目标表上的for - each -row insert触发器。
Therefore during merge-insert operation, only for-each-row insert triggers on the target table are activated.
类似地,在merge -update和merge -delete操作过程中,仅激活目标表上的for - each -row update或者for - each - row delete触发器。
Similarly, during merge-update and merge-delete operations, only for-each-row update or for-each-row delete triggers on the target table are activated.
使用一个简单的XForms触发器创建一个提交按钮,激活的时候调用两个(还可以更多)提交动作,如清单4所示。
A simple XForms trigger is used to create the submit button that upon activation will invoke the two (or more if defined and invoked) submission actions, as shown Listing 4.
它用于引用标准XMLevents属性ev:event,它告诉触发器什么时候激活脚本。
It lets you reference the standard XML Events attribute, ev: event, which tells the trigger when to activate its script.
ForeachRow “选项意味着触发器将在每一行被修改时激活。”
The "for each row" option means that the trigger will be activated once for each row that is modified.
我们的业务规则是支票帐户的余额必须低于0才能激活该触发器。
Our business rule states that a checking balance must fall below zero for the trigger to be invoked.
触发器的启动是在触发事件之前还是之后则称为触发器的激活时间。
Whether a trigger fires before or after the triggering event is known as the activation time of the trigger.
您将注意到,在这种情况下(一个在UPDATE之前被激活的触发器),您只能指定触发器针对每行而不是针对每个语句触发。
You'll notice that in this case (a before trigger invoked by an update), you can only specify that the trigger fire on each row, not each statement.
如果车辆仅激活第一个触发器,计算机知道车辆已停在了交叉路口的边缘。
If the car activates only the first trigger, the computer knows it is stopped at the edge of the intersection.
当对要来的车流是绿灯或黄灯时,计算机点击触发器不激活摄像机。
When the light is green or yellow for incoming traffic, the computer ignores the triggers and does not activate the cameras.
当一辆车激活红灯之后的两个触发器,计算机自动拍取一张照片。
When a car activates both triggers after the light is red, the computer automatically takes a picture.
当一辆车激活红灯之后的两个触发器,计算机自动拍取一张照片。
When a car activates both triggers after the light is red, the computer automatically takes a picture.
应用推荐