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(数据更改操作)不应该出现在连接中。
In trigger terminology, the INSERT, DELETE, or UPDATE that causes a trigger to be fired is known as the triggering event.
在触发器术语中,INSERT、DELETE或者UPDATE这些使得触发器启动的事件被称作触发事件。
Incremental backup is a good way to protect a database that is largely read-only but has some occasional INSERT, UPDATE, or DELETE activity performed against it.
增量备份能够为以只读为主、偶尔执行INSERT、UPDATE或DELETE活动的数据库提供很好的保护。
In a similar manner, you can break up mass UPDATE, DELETE or INSERT operations into separate jobs.
按照类似的方式,您可以将massUPDATE、DELETE或INSERT操作拆成多个不同的任务。
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操作)作用于某张表时,一个定义了一组操作的触发器就可以被激活。
The import utility uses the SQL INSERT statement (or the SQL UPDATE statement) to write data to the target table.
import工具使用SQLINSERT语句(或 SQLUPDATE 语句)将数据写到目标表中。
This query tests that every stored procedure is prefixed with "usp_" followed by "Insert", "Update", "Delete", or "Select", followed by at least one entity name.
此查询测试每个存储过程是否以“usp_”开头,后跟“Insert”、“Update”、“Delete”或“Select”,然后跟至少一个实体名称。
The same considerations as for INSERT statements also apply to SELECT or UPDATE statements.
对INSERT语句的这些考虑同样适用于SELECT或 UPDATE 语句。
The form can have multiple buttons corresponding to any combination of INSERT, UPDATE, or DELETE actions.
表单可有多个按钮对应INSERT、UPDATE或DELETE动作。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
Use TRY..CATCH construct or check the @@ERROR variable after executing a data manipulation statement (like INSERT/UPDATE/DELETE).
在执行数据操作语句(像INSERT/UPDATE/DELETE)之后,使用TRY..CATCH结构或者检查该@@ERROR变量
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中,触发器的开销会很大。
In most cases, well-suited SQL statements are very simple SELECT statements that reference only a single table or are INSERT, UPDATE, and DELETE (UID) operations that are executed many times.
在大多数情况下,非常适合使用参数标记的sql语句要么是非常简单的SELECT语句(只引用一个表),要么是被多次执行的INSERT、UPDATE和DELETE (uid)操作。
For methods starting with insert or update, you may want full transaction propagation; but for other methods, you may want lightweight read-only propagation.
对于以insert或update单词开始的方法,您可能想要完整的事务传播,而对其他方法,您想要轻量级的只读传播。
These re-usable data adapters can have select, update, insert, and delete commands that are either SQL statements or stored procedure calls.
这些可重用数据适配器可以拥有select、update、insert和delete命令,它们或者是sql语句,或者是存储过程调用。
If there were a trigger, for example, you would see that reflected in one or more additional insert, Update, or Delete entries in the access plan.
例如,如果有一个触发器的话,那么就会在访问计划中的一个或多个insert、Update或Delete条目中反映出来。
However, REFRESH IMMEDIATE system-maintained MQTs are updated with changes made to the underlying tables as a result of insert, update, or delete operations.
但是,对于REFRESHIMMEDIATE 类型的系统维护的MQT,可以通过对底层表的更改(即insert、update或delete 操作)来更新。
AtomServer declares a new extension XML element, <asbatch:operation> update (PUT), an insert (POST), or a delete (DELETE).
<asbatch:operation>,以允许客户指明这一Feed里的每个条目是update (PUT)、insert (POST),还是delete (DELETE)。
In theory, you can perform select, insert, update, or delete statements against a table that is not yet redistributed in the database partition group.
理论上讲,可以在数据库分区组中尚未重分发的表上执行select、insert、update或delete语句。
Neither REFRESH DEFERRED nor REFRESH IMMEDIATE system-maintained MQTs allow insert, update, or delete operations to be executed against them.
不管是REFRESHDEFERRED还是REFRESHimmediate类型的系统维护的MQT,对它们的insert、update或delete操作都是不允许的。
They can guard against malicious or incorrect INSERT, UPDATE and DELETE operations and enforce other restrictions that are more complex than those defined with CHECK constraints.
触发器可以预防恶意或错误的INSERT、UPDATE和DELETE操作,并强制执行比CHECK约束中定义的限制更复杂的限制。
Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk.
不鼓励使用诸如INSERT,UPDATE或DELETE之类的语句直接修改授权表及风险自己承担。
Members mapped to database-generated values need to be set to appropriate values after successful completion of INSERT or UPDATE operations.
与资料库产生的值对应的成员,必须在insert或update作业成功完成之后设定为适当值。
Members mapped to database-generated values need to be set to appropriate values after successful completion of INSERT or UPDATE operations.
与资料库产生的值对应的成员,必须在insert或update作业成功完成之后设定为适当值。
应用推荐