The set clause of the UPDATE statement replaces the existing document in a given row with a new document.
UPDATE语句的set子句用一个新文档替换给定行中的现有文档。
A report using the function nestedSet outside the within set clause of an analytic summary function (such as rank) produces the following error.
在一个分析摘要函数(比如rank)的withinset子句外部使用nestedset函数的报告将生成以下错误。
The following case study illustrates the migration of a report that USES the nestedSet function in an expression outside the within set clause of analytic summary function.
下面的案例研究展示如何迁移这样一个报告:报告在分析摘要函数的withinset子句外部的一个表达式中使用nestedset函数。
Usage: This parameter controls the decision on whether or not to apply a NON EMPTY clause on member requests when the number of tuples exceeds the set threshold.
用法:当元组数超过设定的阈值时,该参数控制是否对成员请求应用NONempty子句的决策。
It's usual to explicitly set the model to use as the source for the query, unless otherwise specified with a FROM clause in the RDQL itself.
通常直接设置模型用作查询的源,除非在RDQL中使用FROM子句指定了其他的源。
But a single clause tucked in the 74-page deal agreement set off a series of increasingly dire events that nearly scuttled the rescue brokered and financed by the Fed.
但在74页的交易协议中,有一条不起眼的条款引发了一系列惊人的事件,差点让美联储的救援努力失去意义。
That clause was inserted in 1991, at the insistence of Germany, at the eu summit in Maastricht, the Dutch town where many of the ground rules for the euro were set down.
1991年,在荷兰小城马斯特里赫特召开欧盟峰会,制定欧元运作的诸多基本准则,德国坚持将该条款加入条约。
XMLQUERY is often used in the SELECT clause of an SQL query to extract or construct XML values based on the XML document in a given row of the result set.
在SQL查询的select子句中,常常使用XMLQUERY根据结果集的给定行中的XML文档提取或构造xml值。
The SQL generated by the previous instructions has only a single grouping set in the GROUP-BY clause.
前面步骤产生的SQL在GROUP BY子句中只有一个分组集。
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子句允许您操作操作节点集,随后返回除该节点集以外的结果。
If you use XML predicates in the XMLQUERY function in the select clause of an SQL statement, these predicates do not eliminate any rows from the result set and therefore cannot use an index.
如果在sql语句的select子句的XMLQUERY函数中使用xml谓词,则这些谓词不会从结果集中排除任何行,因此不能使用索引。
The "columns" clause, spanning lines 3 to 5, identifies the specific XML elements that will be mapped to output columns in the SQL result set, specified on line 1.
第3到5行的“columns ”子句标识出将被映射到第一行指定的SQL结果集中的输出列的特定xml元素。
In case you have not set the DB2DBDFT environment variable, all Net Search Extender administrative tasks require the connect to clause, where is the name of your database.
如果还没有设置DB2DBDFT环境变量,那么所有NetSearchExtender管理任务都需要connect to子句,其中的是数据库的名称。
This no longer works if you use arbitrary tables and fields to specify the from clause or the result clause dynamically, though, because the result set types cannot be determined at programming time.
但是,如果使用任意数量的表和字段动态地指定from子句或result子句,就不能这样了,因为在编程时无法确定结果集类型。
Because of the type clause in the class definition, my parameter types coming into the map method are set along with the outputs of this method inside the context.write clause.
由于类定义中的类型子句,我将传入map方法的参数类型设置为在context. write子句内带有该方法的输出。
This is due to the semantics of SQL: without a WHERE clause, SQL queries do not filter out any rows from the table in the returned result set.
这是由于SQL的语义导致的:没有了where子句,SQL查询就不会在返回的结果集中过滤掉表中的任何行。
The parameter object will be used to set input values in an UPDATE statement, or WHERE clause values in a query (etc.).
这个参数对象将用于设置update语句中的输入值,或者用于设置某一查询中的where子句的值(等等)。
As with any database update query, you must pass the YQL query a list of fields to be updated, together with their new values, and a WHERE clause that restricts the update to a set of records.
与任何数据库update查询一样,您必须向YQL查询传递要更新的字段列表,以及其新值和将更新限制为一组记录的一个where子句。
As soon as a cycle is detected the appropriate flag defined in the cycle clause is set and the recursive query process for the branch is stopped.
一旦检测到循环,就会设置cycle子句中已定义好的适当标记,并停止分支的递归查询过程。
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语句级或使用数据库配置参数在数据库级设置隔离级别。
The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.
可在ORDERBY 子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。
Finally, and most importantly, this will ignore any filtering or ordering you perform on the node set returned by the for clause.
最后,也是最重要的,该表达式将忽略对for子句返回的节点集所执行的筛选或排序操作。
If the number of tuples, calculated by using the Cartesian product, exceeds the set threshold; the NON EMPTY clause is applied to the query.
如果通过使用Cartesian产品计算的元组数超过设定的阈值,将NONempty子句应用于查询。
For all rows produced by the start with clause LEVEL is set to 1.
对于通过startwith子句生成的所有行,LEVEL被设置为1。
Also, the plot command can be made to use a different set of axes like x2y2 by using the axes clause.
而且,通过使用axes子句,plot命令可以使用不同的轴集合,如x2y2。
The with clause is the first example where we used something other than a set to customize a graph.
with 子句是我们使用除了set之外的其他项来定制图的第一个例子。
Listing 11 also demonstrates Zorba's support for the XQuery where clause, which is commonly used to filter the output result set.
清单11还显示Zorba对XQuerywhere子句的支持,它通常用于过滤结果集的输出。
You also see that the "set" clause assigns a new value to the XML column "info", and that this new value is the result of an XMLQUERY function.
还可以看到“set”子句给xml列“info”设置一个新值,这个新值是一个XMLQUERY函数的结果。
If you add an order by clause, to order by the extracted city value, the result set still remains the same: Paris, Paris, and Paris are treated as the same value.
如果通过添加order BY子句按提取的city值排序,那么结果集仍然是相同的:paris、paris和paris被当作相同的值。
If you add an order by clause, to order by the extracted city value, the result set still remains the same: Paris, Paris, and Paris are treated as the same value.
如果通过添加order BY子句按提取的city值排序,那么结果集仍然是相同的:paris、paris和paris被当作相同的值。
应用推荐