UPDATE is an INSERT, UPDATE, DELETE, or MERGE operation that may have input parameters and that returns an integer (number of affected rows).
更新是一个INSERT、UPDATE、DELETE或MERGE操作,可以有输入参数,返回一个整数(受影响的行数)。
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.
当一个指定的SQL操作(如DELETE,INSERT,或者是UPDATE操作)作用于某张表时,一个定义了一组操作的触发器就可以被激活。
Since those triggered actions are typically one or more insert, UPDATE, or DELETE statements, the overhead of triggers can be substantial in a mass insert operation.
由于那些被触发的动作通常是一条或多条insert、UPDATE或delete语句,因此,在数据量很大的insert中,触发器的开销会很大。
To avoid too much complexity, DB2 imposes a simple rule: an UPDATE, DELETE or INSERT (data-change-operation) shall never happen in a join unless embedded in a correlated function.
为了避免太多的复杂性,DB 2强加了一条简单的规则:除非嵌入在相关的函数里面,否则UPDATE、DELETE或INSERT(数据更改操作)不应该出现在连接中。
To avoid too much complexity, DB2 imposes a simple rule: an UPDATE, DELETE or INSERT (data-change-operation) shall never happen in a join unless embedded in a correlated function.
为了避免太多的复杂性,DB 2强加了一条简单的规则:除非嵌入在相关的函数里面,否则UPDATE、DELETE或INSERT(数据更改操作)不应该出现在连接中。
应用推荐