Variable assignment / SET statement
变量赋值 /SET语句
Combine chains of SET statements into a single VALUES into statement.
将set语句链组合到单个VALUESinto语句中。
For J2EE applications, you can set statement caching on the application server.
对于J2EE应用程序,您可以在应用程序服务器上设置语句缓存。
FETCH (13) represents the first SET statement in the function, selecting from the ITEM table.
FETCH(13)表示函数中的第一条set语句,它从item表中进行选择。
This is indicated in ESQL SET statement syntax using a colon character to separate the two sections of the Qualified Name.
在ESQLset语句语法中,用冒号分隔限定名(Qualified Name)的两部分,以此来表示这一点。
Use the SET statement to alter existing fields in the logical tree or to create them in circumstances where they do not already exist.
使用set语句来更改逻辑树中现有的字段或者在这些字段不存在的情况下创建它们。
She set the tone for the meeting with a firm statement of company policy.
她坚定地说明了公司的方针,为会议定下了调子。
The result of the rdf.complete function call is a node set of Statement elements.
plete函数调用的结果是Statement元素的一个节点集。
He describes how to use class wrapping of the JDBC driver, connection, statement, and result set objects to instrument JDBC, and hence, database calls.
他介绍了如何使用JDBC驱动、连接、语句、结果集对象的类包装来工具化jdbc,并由此工具化数据库调用。
When you set the statement terminator in an SQL script that contains existing statements, the editor does not update the existing statement terminators automatically.
当您在一个已经包含了语句的SQL脚本中设置语句结束符时,编辑器不会自动修改原有的语句结束符。
Set the SQLXML object into the statement parameters.
将这个SQLXML对象设置为语句参数。
The parameter object will be used to set input values in an UPDATE statement, or WHERE clause values in a query (etc.).
这个参数对象将用于设置update语句中的输入值,或者用于设置某一查询中的where子句的值(等等)。
But a statement object submits different SQL statements to batch, while prepared statement submits a set of parameters to batch.
但语句对象提交不同的sql语句进行批处理,而预置语句提交的是一组参数。
For further flexibility, dynamic SQL allows for changing this option within a plan or package by the SET CURRENT DEGREE statement, which controls the value in a special register.
为获得更大的灵活性,动态SQL允许通过SETCURRENTdegree语句在一个计划或包中更改这个选项,该语句可以控制专用寄存器中的值。
Since only one row is expected in the result set from this SELECT statement, the table scan here is considered an expensive operation.
因为该select语句的结果集中只期望一行,所以表扫描在这里被认为是代价较高的操作。
Execute the prepared statement obtaining a result set.
执行这个预定义语句获取一个结果集。
The SET EXPLAIN statement now supports an optional parameter to override the default name and location of the output file.
SETexplain语句现在支持一个可选的参数,用于覆盖输出文件的默认名称和位置。
This file is cumulative, in other words, if you have multiple SQL queries after SET EXPLAIN on statement, each query execution plan and its costs would be appended to this file until it is removed.
该文件是累积的,换言之,如果SETEXPLAINON语句之后有多个SQL查询,每个查询的执行计划及其成本都会被追加到文件中,直到将之删除。
The second query evaluated USES an SQL statement that returns thousands of result set rows.
测试的第二个查询使用了一条将返回包含数千行数据的结果集的sql语句。
Remember, the SET PASSTHRU statement itself does not test the connection.
记住,SET PASSTHRU语句本身并不能测试该连接。
Additionally, further constraints could also result in the table not being available right after the LOAD operation, requiring you to run the SET INTEGRITY SQL statement first.
此外,进一步的约束还可能导致在LOAD操作之后该表不可用,而要求您首先运行SETINTEGRITYsql语句。
For optimal performance, it is important to have statement caching turned on and set to a reasonable size.
为了实现最佳性能,启用语句缓存并为其设置一个合理大小很重要。
Figure 11 shows an example of the syntax validation error that occurs after you set the statement terminator to an exclamation point (!), and do not update an existing statement terminator.
图11显示的是将语句结束符设置为感叹号(!)但未修改现有语句结束符之后所出现的语法验证错误。
ISOLATION level is set at the session level using set ISOLATION, set at the SQL statement level using the WITH clause or set at the database level using a database Configuration parameter.
使用SETISOLATION在会话级、使用with子句在sql语句级或使用数据库配置参数在数据库级设置隔离级别。
It is not recommended to set SQL_ATTR_REOPT attribute after statement handle is allocated.
不推荐在分配语句句柄之后设置SQL_ATTR_REOPT属性。
The "SET integrity" statement specifies that the MQT is to have integrity checking turned on without being checked for integrity violations.
“SETINTEGRITY ”语句指定,MQT将打开完整性检查,而不检查完整性违反。
Users can also use the set encryption password statement to set an encryption password for a session.
用户还可以使用SETENCRYPTIONpassword语句为一个会话设置一个加密密码。
The federated system provides the SET SERVER OPTION statement.
联邦系统提供SET服务器选项语句。
The set clause of the UPDATE statement replaces the existing document in a given row with a new document.
UPDATE语句的set子句用一个新文档替换给定行中的现有文档。
The set clause of the UPDATE statement replaces the existing document in a given row with a new document.
UPDATE语句的set子句用一个新文档替换给定行中的现有文档。
应用推荐