但语句对象提交不同的sql语句进行批处理,而预置语句提交的是一组参数。
But a statement object submits different SQL statements to batch, while prepared statement submits a set of parameters to batch.
应用程序提交一个SQLupdate语句,把更新后的文档传输给数据库服务器。
The application submits an SQL update statement and transmits the updated document to the database server.
直至最先的事务提交了变化后,其他的事务对所有行发行的相同语句的锁定才被解除。
A subsequent transaction issuing the same statement on any of the rows will be blocked until the first transaction commits its changes.
如果所有语句都成功执行,则将所有更改提交到数据库。
If all statements succeed, all the changes are committed to the database.
首先,应当关闭自动提交模式,这样,每条sql语句的结果不会被自动提交给数据库。
First, you should turn off autocommit mode so the results of each SQL statement aren't automatically committed to the database.
不管数据行是否被提交,以及根据语句的谓词它是否被排除,对于索引扫描和表访问都执行这样的锁定操作。
This locking was done for both index scans and table access whether or not the row of data was committed or whether it would have been excluded based on the statement's predicates.
当您提交该语句时,您必须添加RETURN_GENERATED _ KEYS选项,这将返回自动生成的值。
When you submit the statement, you must add the RETURN_GENERATED_KEYS option, which returns the automatically generated value.
提交语句会将会话数据恢复为之前的提交或回滚语句。
The commit statement restores the session data to the previous commit or rollback statement.
该命令关闭sql语句的自动提交,并删除在CLP交互输入模式下显示的提示符。
This command turns off the automatic commitment of SQL statements and removes the prompt that is displayed in CLP interactive input mode.
为xa通信配置的某些事务管理器会限制应用程序编程人员使用特定于资源管理器的两阶段提交语句。
Some transaction managers configured for XA communication restrict application programmers from using resource manager-specific two-phase commit statements.
第一类开发者需要方便地访问HSQLDBJDBC驱动程序以提交sql语句。
Developers of the first kind need easy access to the HSQLDB JDBC driver so they can submit SQL statements.
最后一个任务是提交select语句并删除一个项。
The last tasks are to submit a SELECT statement and to delete an item.
访问计划是由数据库引擎根据提交的sql语句创建的。
The access plan is created by the database engine based on the SQL statement that is submitted.
提交一个包含了指向db2的sql语句的事务。
Submit a transaction involving SQL statements directed toward DB2.
准备和提交用于执行的语句。
也可以通过- a选项启动SQL编辑器,以自动提交所有sql语句。
You can also start the SQL editor with option -a to automatically commit all SQL statements.
联邦语句的两阶段提交。
在pass - through会话中提交的sql语句和命令不会通过联邦查询编译器。
The SQL statements and commands submitted in a pass-through session do not go through the federated query compiler.
pass- through会话允许直接提交sql语句和部分命令到一个远程服务器。
A pass-through session allows you to submit SQL statements and some subset of commands directly to a remote server.
应用程序提交一个SQL或XQuery语句以读取XML文档。
The application submits an SQL or XQuery statement to read an XML document.
现在,假设名为AppA的应用程序发出以下语句,但是没有执行提交。
Now, assume that an application named AppA issues the following statement, but does not perform a commit.
注意,在清单1中,autocommit值设置为true,这将指示DBMS应该在各数据库语句之后提交本地事务。
Notice in Listing 1 that the autoCommit value is set to true, indicating to the DBMS that the local transaction should be committed after each database statement.
在导入期间,总行数受sql语句的最大可能大小、提交范围(commitscope)、被导入的总行数或所有这些因素的限制。
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.
不仅是把switch语句的范围扩展到字符串上,而且要扩展到其他类型上,这已经是多年来一直反复在提交的一个增强性请求了。
Extending the reach of the switch statement, not only to strings but also to other types, has been the subject of repeated enhancement requests over the years.
如果启用这个新的CS行为(在新的DB 2 9.7数据库中这是默认行为),AppB发出的语句返回当前提交的值,而不需要等待。
When you enable this new CS behavior (it is the default behavior for new DB2 9.7 databases), the statement from AppB returns the currently committed value, instead of waiting.
例如,在自动提交完成后,在commit或rollback发出之前,发出一个select语句。
For example, a select statement is issued with autocommit off and before commit or rollback is issued.
发生COMMIT时,所有未提交的语句(自最近一次COMMIT之后的所有语句)将同时生效,确保数据的完整性。
On a commit, all the uncommitted statements (statements after last commit) take effect together, ensuring data integrity.
TransactionControl (TCL)语句帮助把语句组织为逻辑事务,以便能够提交或回滚它们。
Transaction Control (TCL) statements help in grouping statements into logical transactions so that they can be committed or rolled back.
由JoshuaBloch提交,一个AR M块是try语句的一种形式,声明若干个资源,并且限制在该语句中。
Submitted by Joshua Bloch, an ARM block is a form of the try statement that declares one or more resources which are then limited to that statement.
如果有一个包含大量读取操作的工作负载,那么您可能想将隔离级别设置为未提交读取(UR),从而不需要在每个语句中设置隔离级别。
If you have a read-heavy workload, you might want to set isolation to uncommitted read (UR) at the connection level so that you don't have to specify it in each statement.
应用推荐