如果令牌之间的时间间隔在一天的不同时间是不同的,您可以使用时间表触发器。
If the time between tokens varies according to the time of day, you can use a timetable trigger.
在这种情况中,你把文档添加到模型的每一个元素中,包括每个列,每个表,每个约束和每个触发器。
In this activity, you add documentation to every element in the model, including every column, every table, every constraint, and every trigger.
完成验证后,实用程序即创建一个增量值为1的序列对象,并为相关联的表创建一个触发器。
After this verification, the utility creates a sequence object with an increment value of 1, and then creates a trigger for the associated table.
一个触发器只能关联一个表,而不能关联一个视图。
A trigger can only be associated with a table and not a view.
一些新的特性扩展了表和视图上的触发器的语法和功能。
Several new features expand the syntax and functionality of triggers on tables and on views.
下面的说明逐步地为该客户订单示例完成新的DB 2数据库以及必要的表和触发器的创建。
The following instructions walk through the creation of a new DB2 database along with the necessary tables and triggers for the Customer Order Example.
在触发器、动态合成语句、标量、表、行函数和方法中不能调用具有访问级别MODIFIESSQLDATA的联邦过程。
Federated procedures with access level MODIFIES SQL DATA cannot be invoked inside triggers, dynamic compound statements, scalar, table, row functions, and methods.
而且,需要指定与该触发器相关的表的名字。
Also, specify the table name that is associated with the trigger.
注对于添加了空间列的源表,根本不需要这个触发器;一旦删除了一行,它就消失了。
NOTE in the case of a single, integrated table, this trigger is not needed at all; once a row is deleted, that's it.
当其中一个数据库触发器运行时,将填充事件存储表。
The event store table gets populated when one of the database triggers runs.
更改是通过在源表中创建的触发器完成跟踪的。
Changes are tracked through triggers that are created on the source table.
注意:您也可以选择创建一个数据库触发器来捕捉表上的每个INSERT操作,并告诉它在执行INSERT之前使用XMLVALIDATE函数验证XML数据。
Note: Alternatively you can create a database trigger to capture every INSERT on your table and tell it to validate the data as XML using the XMLVALIDATE function before performing the INSERT.
复制目标(在本地系统上)是一个真正的表,所以本文中描述的基于触发器的机制是可行的。
The replication target (on the local system) would be a real table, so the trigger-based mechanism outlined in this article would work.
因为不能使用触发器来及时更新空间表,所以需要在定期调度机制中使用批量复制机制。
Since triggers are not available to keep the spatial table up to date, you need to use the bulk copy mechanism as part of regularly scheduled mechanism.
带有表参数的过程只能从触发器的触发操作调用。
A procedure with a table parameter can only be invoked from the triggered action of a trigger.
这里展示的任务可能是微不足道的,但它也能轻松处理跨多个表、执行触发器等的SQL语句。
The task here may have been trivial, but this could just as easily have been an SQL statement that spanned multiple tables, executed triggers, and so on.
DB 2支持许多种数据库服务器端编程语言,包括存储过程、触发器和函数(表函数和标量函数)。
DB2 supports many database server-side programming languages, including stored procedures, triggers, and functions (table and scalar).
不能为外部表定义触发器。
创建db2表和触发器。
DB 2中的模式(schema)是一个命名对象集合,这些对象包括表、视图、昵称、触发器、函数和包。
A schema in DB2 is a collection of named objects, such as tables, views, nicknames, triggers, functions, and packages.
创建表、视图、索引、触发器等的ddl语句。
Generate DDL statements for tables, view, indexes, triggers, and more.
Triggers视图—允许向表添加触发器。
该特性允许访问触发器中所谓的过渡表(transition table)。
This feature allows access to what is known as transition tables in triggers.
因此,在merge -insert操作过程中,仅激活目标表上的for - each -row insert触发器。
Therefore during merge-insert operation, only for-each-row insert triggers on the target table are activated.
通过使用新的DataBladeAPI 例程,可以编写通用的用户定义例程来审计表和触发器事件。
Using the new DataBlade API routines, you can write a general purpose user-defined routine that can you can use to audit any table and any trigger event.
edition表上的after - insert触发器并非很有用,因为它只能截获其status值为start的记录行。
An after-insert trigger on the IWH.EDITION table is not useful, as only rows with a status value of start would be intercepted.
向数据库添加触发器,以便对该表中的记录的每个更新都会导致修订计数器递增。
We add a trigger to database so that every update to a record in the table increments the revision counter.
TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
数据库触发器是驻留在数据库中的程序,当数据库中的表发生更新之类的事件时会运行该触发器。
A database trigger is program residing in the database that runs when an event, such as an update, occurs on a table in the database.
例如,触发器、限制和索引都包含在特定的的表中。
For example, triggers, constraints, and indexes are contained within a particular table.
应用推荐