The transaction time includes the time at which an application's statement activity begins until a commit or rollback implicitly or explicitly ends the transaction.
事务时间包括从应用程序的声明活动开始,直到一条提交或回滚命令隐式或显式地结束事务为止。
The commit statement restores the session data to the previous commit or rollback statement.
提交语句会将会话数据恢复为之前的提交或回滚语句。
Be sure to issue the COMMIT statement frequently in your application.
要确保在您的应用程序中经常发出commit语句。
Issuing a COMMIT records all the work since the last COMMIT statement "for keeps" in the database.
发出commit会将自上一个commit语句之后的所有工作“永远”记录到数据库中。
The default transactional behavior is auto-commit mode, where each statement is committed as it is sent to the target server.
默认的事务行为是自动提交模式。在该模式下,每个语句在发送到目标服务器时进行提交。
As with bulk loads from a file, therefore, it is better to issue a COMMIT statement periodically, so the logical log files can be flushed.
因此,在从文件进行批量装载时,最好是定期发出commit语句,这样就可以刷新逻辑日志文件。
In order for the policy changes to take effect, you must issue a COMMIT statement after invoking these procedures.
为了使策略更改生效,必须在调用这些过程后发出commit语句。
The remote procedure referenced by the federated procedure must not issue a COMMIT or a ROLLBACK statement.
联邦过程所引用的远程过程不能发出COMMIT或rollback语句。
Since there is no COMMIT between the INSERT and SELECT statement, potentially the deadlock is caused by a table scan.
由于INSERT和select语句之间没有COMMIT,死锁可能是由表扫描引起的。
A COMMIT statement controls the unit of work.
commit语句控制工作单元。
For example, a select statement is issued with autocommit off and before commit or rollback is issued.
例如,在自动提交完成后,在commit或rollback发出之前,发出一个select语句。
Those X-locks persist until the transaction is ended by a COMMIT or a ROLLBACK statement.
这些独占锁会一直持续下去,直到使用COMMIT或rollback语句结束事务。
Now, assume that an application named AppA issues the following statement, but does not perform a commit.
现在,假设名为AppA的应用程序发出以下语句,但是没有执行提交。
Since you cannot enforce this restriction, data inconsistencies may occur if the remote procedure has a COMMIT or ROLLBACK statement (see the Transaction issues with call statements section below).
因为不能强制实施这一限制,如果远程过程有COMMIT或rollback语句,就可能发生数据不一致(见下面的call语句的事务问题一节)。
Before issuing the COMMIT, you could roll back the work using the ROLLBACK statement.
在发出COMMIT之前,可以使用rollback语句回滚工作。
During import, the total number of rows is constraint by the maximum possible size of the SQL statement, the commit scope, the total number of rows being imported, or all of these.
在导入期间,总行数受sql语句的最大可能大小、提交范围(commitscope)、被导入的总行数或所有这些因素的限制。
Moreover, most of the attention has been focused on boards of directors at companies that commit financial statement fraud (specifically, on the role of the audit committee of the board).
而且,大部分注意力被集中在指使财务欺诈的公司懂事会之上(明确的说,是懂事会的审计委员会)。
Use the COMMIT statement to end your current transaction and make permanent all changes performed in the transaction.
使用COMMIT可以终止你当前的事务,并永久性地改变 数据库中的数据(写到日志文件)。
Use the COMMIT statement to end your current transaction and make permanent all changes performed in the transaction.
使用COMMIT可以终止你当前的事务,并永久性地改变 数据库中的数据(写到日志文件)。
应用推荐