cte

cte

美 　英

• 网络热膨胀系数(coefficient of thermal expansion)；公用表表达式(common table expression)；贸易与环境委员会(Committee on Trade and Environment)

例句

The recursive CTE definition must contain at least two CTE query definitions, an anchor member and a recursive member.

递归CTE定义至少必须包含两个CTE查询定义，一个定位点成员和一个递归成员。

The CTE value of composites after solution and ageing treatment decrease obviously compared with that of annealing treatment.

复合材料固溶时效后的热膨胀系数与退火态相比明显降低。

Because these query definitions form the base result set of the CTE structure, they are referred to as anchor members.

由于这些查询定义形成了CTE结构的基准结果集，所以它们被称为“定位点成员”。

A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query.

CTE与派生表类似，具体表现在不存储为对象，并且只在查询期间有效。

Today, vocational education is usually called career and technical education, or CTE.

今天，“职业教育”通常也叫“职业和技术教育”，或是CTE（职业和技术教育）。

A common table expression (CTE) provides the significant advantage of being able to reference itself, thereby creating a recursive CTE.

公用表表达式（CTE）具有一个重要的优点，那就是能够引用其自身，从而创建递归CTE。

The recursive CTE structure must contain at least one anchor member and one recursive member .

递归CTE结构必须至少包含一个定位点成员和一个递归成员。

When a CTE is used in a statement that is part of a batch , the statement before it must be followed by a semicolon .

如果将CTE用在属于批处理的一部分的语句中，那么在它之前的语句必须以分号结尾。

A recursive CTE is one in which an initial CTE is repeatedly executed to return subsets of data until the complete result set is obtained.

递归CTE是一个重复执行初始CTE以返回数据子集直到获取完整结果集的公用表表达式。

The following pseudocode shows the components of a simple recursive CTE that contains a single anchor member and single recursive member.

以下伪代码显示了包含一个定位点成员和一个递归成员的简单递归CTE的组件。

A CTE can also be used in a CREATE VIEW statement as part of its defining SELECT statement.

CTE也可用于CREATEVIEW语句，作为定义SELECT语句的一部分。

A CTE is made up of an expression name representing the CTE, an optional column list, and a query defining the CTE.

CTE由表示CTE的表达式名称、可选列列表和定义CET的查询组成。

A CTE can also be specified in a CREATE VIEW statement as part of the defining SELECT statement of the view.

也可以在CREATEVIEW语句中将CTE指定为视图中SELECT定义语句的一部分。

CONCLUSION: CTE can be effectively treated with the weekly reverse manipulation and serial long leg casting.

结论：应用逆转手法按摩、系列石膏固定治疗先天性马蹄内翻足效果显著。

To date, all known cases of CTE involve victims who have taken repeated blows to the head, through contact sports like football and boxing.

迄今为止，所有已知的热膨胀系数案件涉及谁已多次打击头部通过喜欢足球和拳击接触的运动，受害者。

The variation of CTE values of the unidirectional hybrid composites with hybrid ratio, hybrid interfaces and ply order is studied.

研究了单向混杂复合材料热膨胀系数随混杂比、混杂界面数及铺层顺序等参数变化的规律。

The CTE result set is derived from a simple query and is referenced by UPDATE statement.

CTE结果集派生自简单查询并由UPDATE语句引用。

The coefficient of thermal expansion (CTE) is one of the most important indexes to volume stability of concrete.

混凝土的热膨胀系数是体积稳定性的重要表征参数之一。

Unlike a derived table , a CTE can be self- referencing and can be referenced multiple times in the same query .

与派生表的不同之处在于，CTE可自引用，还可在同一查询中引用多次。

After a CTE is defined, it can be referenced like a table or view can in a SELECT, INSERT, UPDATE, or DELETE statement.

定义CTE后，可以在SELECT、INSERT、UPDATE或DELETE语句中对其进行引用，就像引用表或视图一样。

The function uses a recursive common table expression (CTE) to produce the hierarchical list of employees.

该函数使用递归公用表表达式（CTE）来生成雇员的层次结构列表。

This second select statement is joined with the Common Table Expression (CTE) itself by linking parent to child data.

第二个SELECT语句通过将父数据链接至子数据与公共表表达式（CTE）联接。

The coefficient of thermal expansion (CTE) of composites influence the thermal stress in the composite gun barrel.

热膨胀系数直接影响复合材料身管射击时热应力的大小。

In contrast with metal and thermoplastic material, which has a higher coefficient of thermal expansion(CTE).

相较于金属和热塑材料，什么材料具有更高的热膨胀系数（CTE）？

The repeated head trauma they suffer can lead to a disease called Chronic Traumatic Encephalopathy, or CTE.

他们一再遭受头部外伤可导致疾病叫做慢性创伤性脑病，或热膨胀系数。

Although a recursive routine in other languages returns a scalar value, a recursive CTE can return multiple rows.

尽管其他语言中的递归例程返回标量值，但递归CTE可以返回多行。

Specifying more than one WITH clause in a CTE is not allowed.

不允许在一个CTE中指定多个WITH子句。

Using a CTE offers the advantages of improved readability and ease in maintenance of complex queries.

使用CTE可以获得提高可读性和轻松维护复杂查询的优点。

In a recursive CTE, it is simply any query providing a set of rows.

在递归CTE中，它只是一个普通的提供一组行的查询。

California has pursued similar reforms; CTE's main champion is Arnold Schwarzenegger.

加州州长阿诺德施瓦辛格是CTE的有力支持者，加利福利亚也将继续推进类似的改革。

Instead of sitting in a crowded classroom taking notes, students in CTE programs learn a trade.

相比在拥挤的教室里记笔记，CTE项目的学生学习贸易。

A query referencing a CTE can be used to define a cursor.

可以使用引用CTE的查询来定义游标。

The structure of the recursive CTE in Transact-SQL is similar to recursive routines in other programming languages.

Transact-SQL中的递归CTE的结构与其他编程语言中的递归例程相似。

The statement that executes the CTE limits the result set to employees in the Research and Development Group.

执行CTE的语句将结果集限制到研发组中的雇员。

The SELECT statement cannot contain a common table expression (CTE).

SELECT语句不能包含公用表表达式（CTE）。

Using a CTE allows the use of recursive queries and can simplify logic by replacing the use of temporary tables or views.

利用CTE，可使用递归查询并可通过取代临时表或视图来简化逻辑。

The recursive invocation includes one or more CTE_query_definitions joined by UNION ALL operators that reference the CTE itself.

递归调用包括一个或多个由引用CTE本身的UNIONALL运算符联接的CTE_query_definitions。

Are considered anchor members unless they reference the CTE itself.

被视为定位点成员，除非它们引用了CTE本身。

In SQL Server 2005, a query is referred to as a recursive query when it references a recursive CTE.

在SQLServer2005中，当某个查询引用递归CTE时，它即被称为“递归查询”。

An incorrectly composed recursive CTE may cause an infinite loop.

如果递归CTE组合不正确，可能会导致无限循环。