The for clause binds the variable $y to each address in turn.
for 子句依次将变量 $y 绑定到每个地址。
The for clause binds variable $p to each of these ProductID values in turn.
for 子句依次将变量 $p绑定到每个ProductID值。
For the first time, you see that a for clause can define more than one variable.
您第一次看到for子句可以定义多个变量。
Take a look at the example in Listing 2, which USES more than one for clause.
看一下清单2中的示例,其中使用了多个for子句。
Ensure that the user ID or PUBLIC is defined in the WITH use FOR clause of the trusted context.
确保在可信上下文中的WITHUSEfor子句中定义了用户ID或PUBLIC。
The FOR clause of this function loops through the entity nodes contained in the transient XML data.
该函数的for子句循环通过包含在临时XML数据中的实体节点。
For now, though, always ensure you have the variable defined in your for clause reappearing in your return clause.
目前,先要记住必须保证for子句定义的变量同时出现在return子句中。
In addition to the let and return clauses, Zorba supports for sequences, as well as the for clause to process them.
除了let和return子句之外,Zorba还支持序列和处理序列的for子句。
Each FLWR expression has one or more for clause, one or more let clause, an optional where clause, and a return clause.
每个FLWR表达式都有一个或多个for子句、一个或多个let子句、一个可选的where子句以及一个return子句。
Finally, and most importantly, this will ignore any filtering or ordering you perform on the node set returned by the for clause.
最后,也是最重要的,该表达式将忽略对for子句返回的节点集所执行的筛选或排序操作。
Without the FETCH FIRST (or similarly, but not exactly, without an OPTIMIZE FOR clause), then DB2 would almost certainly prefer some other access path.
没有FETCHFIRST(或者类似地,但是并不确切,是没有一个OPTIMIZEfor子句),那么DB 2毫无疑问会选择其他访问路径。
Listing 7 defines a sequence of names, and then USES a for clause to loop through this sequence, retrieving each name and adding it to a node collection.
清单7定义一个序列名,然后使用一个for子句遍历该序列,获取每个名称并将其添加到节点集合中。
You most often will use variables in XQuery as shown above, though, where the variable is created implicitly by a for clause, rather than explicitly with a let clause.
多数情况下按照上述方法使用XQuery中的变量,即通过for子句隐式建立变量,而不是使用let子句显式地定义变量。
The distinct-values function in the for clause returns a list of all the distinct values of ProductID that are found inside comments in the comments column of the Items table.
for子句中的distinct -values函数返回一个列表,其中包含在items表的comments列中的所有Comment中发现的所有不同的productid值。
According to the FLWR expression characteristics, the algorithm is divided into three parts: decomposing the LET and FOR clause, handling RETURN clause and WHERE condition.
根据FLWR表达式的特点,算法共分为三个部分:分解FOR和LET子句、处理RETURN子句和处理WHERE条件。
By using the for clause in the after-aggregation detail filter on a non-projected data item, the underlying query automatically projects and groups the item as the outer most column of the list.
通过在一个未投射的数据项上的after - aggregation细节过滤器中使用for子句,底层查询会自动将该项目投射并分组为列表的最外层列。
They joined with the monarchists to insert a clause calling for a popular vote on the issue.
他们与君主制主义者一起添加了一个条款,要求对该问题进行全民投票表决。
The next step is to execute the appropriate SQL query to construct your updateable cursor, which requires using the FOR UPDATE clause as described earlier.
下一步是执行适当的SQL查询来构造可更新的游标,方法为根据先前的描述使用 FORUPDATE子句。
It will not use a FOR UPDATE clause when loading the data, so the rows will not be locked.
在装载数据时它并不使用FOR update子句,所以行并不会被锁定。
Include WHERE clause predicates for only the columns that are important and relevant to us.
在重要的、与我们相关的列中包含where子句谓词。
The Buy America clause allows, for example, imports from the 38 countries with which the United States has trade agreements.
“购买美国货”条款允许从与美国签署协议的38个国家(地区)进口。
A FOR FETCH ONLY clause is added to the Select statement to avoid record locking and to take advantage of SQL automatic blocking.
一个FOR FETCHonly子句被添加到select语句,以避免记录锁定并利用SQL自动块操作的优势。
FOR update clause to obtain an update lock.
FORupdate子句来获取更新锁定。
This can be performed by invoking the CREATE TABLE statement using the CCSID UNICODE clause. For example.
这可以通过调用使用了CCSIDunicode子句的CREATEtable语句来执行。
The correct answer is to use a hash syntax for the :include clause.
正确的答案是使用 :include 子句的哈希语法。
Notice the second clause to the for expression in Listing 12?
注意到清单12中for表达式的第二个子句了吗?
If you do not specify anything for this clause, audit records from all databases in the instance are eligible for extraction.
如果该子句未指定任何内容,那么可以提取来自实例中任何数据库的审计记录。
For this reason, you should append a 'for FETCH ONLY' clause to those queries that will not be update targets, or use 'BLOCKING ALL' as one bind option for your application.
由于这个原因,您应该将'FOR FETCHONLY '子句加在不会成为更新目标的查询的后面,或者使用'BLOCKINGALL '作为应用程序的一个绑定选项。
Beyond the embedded original SQL query, no representation is kept of the table or tables that were queried for data (the "FROM" clause).
除了嵌入的原始sql查询以外,没有保留用于查询数据的一个或多个表的表示(“FROM ”子句)。
Support for constants in ORDER BY clause have been depreciated.
支持ORDERBY子句中使用常量已经过时。
应用推荐