Completing a query with the return clause.
用return子句完成查询。
Declare the cursor using the WITH RETURN clause.
使用WITHreturn子句声明游标。
RETURN: The return clause returns the modified values.
return：return子句返回修改后的值。
The return clause defines what to return for each tuple.
return子句定义每个元组要返回的内容。
However, the return clause of XQuery enables you to transform XML output as needed.
不过，通过XQuery的return子句可以按照需要转换XML输出。
The return clause constructs a new product element for each distinct ProductID value.
return子句为每个不同的productid值构造一个新的“product”元素。
Declare cursors for each of the result sets to be returned that specify the WITH return clause.
对于每个将要返回的结果集，使用WITHreturn子句声明游标。
A transform expression starts with the optional "transform" keyword followed by a COPY, MODIFY, and a RETURN clause.
转换表达式的开头是可选的“transform”关键字，然后是COPY、MODIFY和return子句。
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子句。
Even though the query accesses a new element, its access is limited to the return clause-that is, it is not restrictive.
虽然查询访问新元素，它的访问也仅限于return子句—就是说是非限定性的。
In Update 1, and many other typical use cases, the return clause simply returns the variable that holds the modified document.
在更新1和其他许多典型场景中，return子句仅仅返回包含修改后的文档的变量。
Return: Using a return clause lets you operate on a node set, but then return (in results) something other than that node set.
return：使用return子句允许您操作操作节点集，随后返回除该节点集以外的结果。
In addition, the return clause in this query contains conditional logic to determine if an E-mail element is present in a given customer's record.
此外，这个查询中的return子句包含一个条件逻辑，用于判断给定客户的记录中是否存在e- mail元素。
The contents are extracted with the data() function in the return clause; otherwise, I'd get more than just the text in the node, I'd get all the markup, too.
内容是用return子句中的data()函数提取的；否则，不仅仅会得到节点中的文本，还会得到所有的标记。
As another example, Update 29 USES the COPY clause to only get the customer's address, and the RETURN clause to embed the modified address in a new "sendto" element.
更新29给出另一个示例，它使用COPY子句只获取客户的地址并在return子句中把修改后的地址嵌入新的“sendto”元素。
Finally, the return clause returns the new node representing the scheduled termination date so that DB2 will update data in the DOCUMENT column with the modified data.
最后，return子句返回代表预定终止日期的新节点，所以DB 2将用修改后的数据更新document列中的数据。
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条件。
For each of these nodes, it computes the expression in the return clause, which here is a mix of markup (the tags) and code (extracting the contents of the element of each node).
对于选出的每个节点，将在return子句中计算表达式，在这里是标记(标签)与代码(提取出每个节点的元素的内容)的混合。
The return value of any function is the result of the last expression in that clause (in our examples there is only one line).
任何函数的返回值都是子句(在我们的示例中只有一行)中最后一个表达式的结果。
The data type for the function return type can be specified directly or using the REFERENCES clause.
函数返回类型的数据类型可以直接指定，或使用references子句指定。
When the BULK COLLECT clause is included, the statement can return multiple rows; the variable in the INTO clause must be an array, and each row is stored in an array element.
在包括BULKCOLLECT子句后，该语句可返回多行；INTO 子句中的变量必须是阵列，且每一行存储在一个阵列元素中。
If the statement is not successful, the value of SQLERRNUM is captured and returned to the caller using the return statement and the RETURNS clause.
如果语句不成功，将使用return语句和returns子句捕捉SQLERRNUM的值并返回给调用者。
The following example shows a SELECT statement with a hierarchical query clause to return all direct subordinates for the manager Meier (employee number 101).
下列示例显示使用一个SELECT语句和一个分级查询子句来返回Meier经理（雇员编号为 101）的所有直接下属。
The SELECT clause specifies what the query should return — in this case, a variable named url.
select子句指定查询应当返回的内容，在这个例子中，返回的是名为url的变量。
The order by posted desc clause forces the query to return rows in descending order by the date in the posted column (which is the date that the article was posted on the Web site).
orderbyposteddesc子句强迫此查询按posted列中的日期(即文章发布到Web站点的日期)的降序返回行。
It can be used in the WHERE clause of an SQL statement to select only the rows that return non-trivial XML values for the XPath expression.
可以在sql语句的where子句中使用它只选择那些对于XPath表达式返回非空xml值的行。
Adding an ORDER siblings BY clause which is only allowed in composition with the hierarchical query clause and will return the siblings in the predefined sequence.
添加一个ORDERSIBLINGSBY子句，该子句只能与分级查询子句组合使用，并且将按预先定义的顺序返回同级查询结果。
The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.
可在ORDERBY 子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。
应用推荐