The values can be derived from any expression in the SQL language.
在SQL语言中可以从任何的表达式派生这些值。
You can specify these expressions by double-clicking each row, which causes another window to appear with an area for building or typing SQL expressions.
可以通过双击每行指定这些表达式,这将显示另一个窗口,其中有一个文本区用于构建或输入SQL表达式。
The heterogeneous nature of XML data conflicts with the SQL assumption that every expression inside a query returns an array of rows and columns.
SQL假设查询内的每一个表达式都返回一个行和列的数组,而XML数据的异构本质与之相冲突。
When generating SQL expressions for measures that reference other measures, the aggregation function might not be used to form the SQL expression for the nested measures.
如果一个度量引用其他度量,那么在为它产生SQL表达式时,不能使用聚合函数来为嵌套的度量产生SQL表达式。
In general, each value in the enumeration can be an arbitrary scalar SQL expression.
一般情况下,枚举中的每一个值都可以成为任意标量SQL表达式。
As part of the transformation, the optimizer also determines the correct table join order, rewrites expressions, and eliminates any redundancy from the SQL.
作为转换的一部分,优化器还决定正确的表联接顺序,重写表达式,并从SQL中消除任何冗余。
There is also a SQL editor control that contains intellisense capabilities to edit the check constraint expression.
还存在一个包含智能能力的SQL编辑器控件,用于编辑检查约束表达式。
A FLWOR expression is much like a SELECT-FROM-WHERE expression in SQL: it is used to iterate through a list of items and to optionally return something that is computed from each item.
FLWOR表达式非常像SQL中的SELECT - FROM - WHERE表达式——它用于对由多项组成的一个列表进行迭代,并且可以选择返回通过在每一项上进行计算得到的值。
To use a table subquery, you need to use an SQL operator to combine the embedded query with a Boolean expression.
要使用表子查询,需要使用SQL操作符将嵌入式查询与布尔表达式组合在一起。
When you use transform expressions in SQL update statements, you rarely have a filtering predicate in the COPY clause but rather in the SQL WHERE clause.
在SQL更新语句中使用转换表达式时,很少在COPY子句中使用筛选谓词,通常是在 SQL WHERE 子句中进行筛选。
Like topic selection, message selection criteria expressions are defined using a SQL-like syntax, which must resolve to a Boolean value.
和主题选择一样,消息选择标准表达式使用sql样式的语法定义,该语法必须求解出一个布尔值。
If there are to be any predicates on any attributes of the facts object, then these attributes also need to be converted into SQL expressions.
如果事实对象的任何属性上有任何谓词,那么这些属性也需要转换为SQL表达式。
Commonly abbreviated to "FLWOR" these expressions may be used for performing joins across multiple XML streams in a similar manner to SQL.
通常缩写为“FLWOR ”的这些表达式可以被用于以类似SQL的方式执行跨多个XML流的连接。
Topic selection expressions are defined using an SQL-like syntax.
主题选择表达式使用一种sql样式的语法定义。
Add the SQL expressions generated for each of these attributes as columns in the SELECT list.
将这些属性的SQL表达式添加到SELECT列表中作为列。
Most of the examples in this article show the transform expression in an SQL UPDATE statement.
本文中的大多数示例在SQLupdate语句中使用转换表达式。
The attributes selected in this step, along with the list of measures, are used to create all of the SQL expressions, which are used in the SQL statement.
在这一步中选择的属性(以及度量的列表)用来创建sql语句中使用的所有SQL表达式。
SQL expressions will need to be created from these attributes to form the join predicates of the SQL statement.
需要从这些属性创建SQL表达式,从而形成sql语句的联结谓词。
Rather, just the expression resulting from the SQL expression template should be used from the nested measures.
相反,应该只使用嵌套度量的SQL 表达式模板产生的表达式。
Convert expressions into SQL so that they can be executed by a server (this is what LINQ to SQL does).
将表达式转换为sql,这样他们就能被服务器执行了(这是linq到sql所做的工作)。
The attributes on this side will need to be converted to SQL expressions to form the join predicates of the SQL statement.
这一边上的属性需要转换为SQL表达式,从而形成sql语句的联结谓词。
Combining regular expressions with SQL provides many alternative means of processing data.
将正则表达式与SQL结合起来可以提供许多处理数据的可选方法。
According to the SQL Standard, the method to evaluate hierarchical or bi-directional data is the Recursive Common Table Expression (RCTE).
根据SQL标准,评估分层或双向数据的方法为递归通用表表达式(RCTE)。
Regular expressions are not new to SQL.
正则表达式对SQL 来说并非新事物。
Generating SQL expressions from the measures of the facts object is similar to the description of how to generate SQL expressions for attributes.
从事实对象的度量产生SQL表达式类似于为属性产生SQL表达式。
Generating SQL expressions from the attributes of the facts object is done the same way as the attributes of the dimensions.
从事实对象的属性产生SQL表达式的方式与维属性相似。
All of the SQL expressions for any attributes that were selected as columns in the select clause should also be in the GROUP BY clause.
对于作为select子句中的列的任何属性,它们的SQL表达式也应该放在GROUP by子句中。
The syntax for the SQL VALUES expression is fairly simple, as shown in Listing 6.
SQLVALUES表达式的语法相当简单,如 清单6 所示。
The VALUES... into statement allows an SQL expression to be executed and to return the result into variables.
VALUES…into语句允许执行SQL表达式,并将结果返回至变量。
It is treated as the SQL expression.
它被当作SQL表达式。
应用推荐