Subqueries英文翻译_含义_读音_Subqueries例句

The previous restrictions apply to any subqueries in the FROM clause of the view, just as they apply to the view itself.

上述限制适用于视图的FROM子句中的任何子查询，就像其应用于视图本身一样。

The uncorrelated subqueries do not rely on the main query for information; hence they increase the power and flexibility of your main query.

不相关的子查询不依靠主查询来获取信息；因此，它们增加了主查询的能力和灵活性。

Total number of rows processed by the SQL statement. This total does not include rows processed by subqueries of the SQL statement.

sql语句处理的总行数。这个总行数不包括子查询处理的行数。

Correlated subqueries are often used to test whether relationships exist without regard to cardinality.

相关性查询通常用于测试某种关系是否存在，而不管返回记录集的大小，

Note: Transactions containing DML statements with subqueries should use serializable isolation to guarantee consistent read.

如果事务中存在使用了子查询的DML语句，应该使用串行化隔离来保证一致性的读取。

Query hints can be specified only in the top-level query, not in subqueries.

只能在顶级查询中指定查询提示，不能在子查询指定。

Subqueries used in the subquery comparison test and set membership test both return data values from the subquery table.

在子查询比较测试中使用的子查询和在集合成员资格测试中使用的子查询都从子查询表返回数据值。

The expressions used in the SET clause can also be subqueries that return only one value.

SET子句中使用的表达式还可以是只返回一个值的子查询。

Expressions may be reordered and subqueries may be transformed to improve processing efficiency.

可以对表达式进行重新排序并对子查询进行转换以提高处理效率。

Similarly, subqueries impose a certain order of join execution that may not be the most advantageous.

类似地，子查询会使连接按照一定的顺序执行，而这种顺序也许不是最优的。

This tutorial describes subqueries stated as conditions in the WHERE clause, which are useful for simpler comparison queries.

本教程描述在WHERE子句中作为条件的子查询，这些子查询对于较简单的比较查询很有用。

The subqueries aggregate the sales for each sales person within the UPDATE statement.

这些子查询通过UPDATE聚合了语句中每个销售人员的销售信息。

The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

除非同时指定了TOP，否则ORDERBY子句在视图、内联函数、派生表和子查询中无效。

These access operations translate to more complex joins or correlated subqueries in the equivalent SQL.

这些访问操作会转换成用等效的SQL表示的更为复杂的联接或关联子查询。

Removed inaccurate content about using subqueries in scalar_expression.

删除了有关在scalar_expression中使用子查询的不准确内容。

The statement must not contain subqueries, outer joins, or self-joins.

语句不能包含子查询、外部联接或自联接。

UNION and JOIN within a FROM clause are supported within views and in derived tables and subqueries.

视图、派生表和子查询中均支持FROM子句内的UNION和JOIN。

So the existence test applied to the following two subqueries return the same results.

因此，应用于以下两个子查询的存在测试返回相同的结果。

You can select, insert, and update the XML values using SQL statements with embedded XQuery subqueries.

使用具有嵌入的XQuery子查询的SQL语句，可以选择、插入并更新XML值。

Create or modify joins between tables, views, user-defined functions, or subqueries.

创建或修改表、视图、用户定义函数或子查询间的联接。

This includes SELECT lists of subqueries and SELECT lists inside INSERT statements.

其中包括子查询的SELECT列表和INSERT语句中的SELECT列表。

Also, subqueries, aggregates, and constant expressions are not allowed in the ORDER BY list.

此外，在ORDERBY列表中也不允许使用子查询、聚合和常量表达式。

Next, several examples of FROM clause and select-list subqueries are presented.

接着，我们会给出一些关于FROM子句和select列表子查询的例子。

Aggregate functions and subqueries are not permitted.

不允许聚合函数和子查询。

This example uses two correlated subqueries to find the names of employees who have sold a particular product.

此示例使用两个相关子查询查找售出过某种特定产品的雇员的姓名。

No columns, variables, or subqueries appear in the expression.

表达式中没有列、变量、或子查询。

The rewrite phase is particularly important for queries that are very complex, such as queries with many subqueries or joins.

对于非常复杂的查询，例如带有很多子查询或连接的查询，重写阶段尤其重要。

Perhaps the most important use for the IN keyword is in nested queries, also called subqueries.

或许IN关键字最重要的用法是用在嵌套查询（也称作子查询）中。

The article also demonstrated how to modify a more complex database schema by using embedded subqueries.

本文还演示了如何通过使用嵌入式子查询来修改比较复杂的数据库模式。

You can use the GROUP BY clause, subqueries, and joins in view definitions.

您可以在视图定义中使用GROUPBY子句、子查询和连接。