Common table expressions

Common table expressions

A Common Table Expression (in SQL) is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement.

CTE can be thought of as an alternatives to derived tables (subquery), views, and inline user-defined functions.

External links

* [http://www.sqlmag.com/articles/index.cfm?articleid=42072& Getting in the loop with CTEs]
* [http://msdn2.microsoft.com/en-us/library/ms190766.aspx MSDN tutorial]
* [http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/11/common-table-expressions-cte-s-how-it-works-how-recursion-works-using-with-adjacency-list.aspx Tony Rogerson's Blog entry on how CTE's work and how to do recursion using an adjancey list as an example in Microsoft SQL Server]


Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • Common table expression — A Common Table Expression, or CTE, (in SQL) is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement. CTEs can be thought of as alternatives to derived… …   Wikipedia

  • Common Lisp — Paradigm(s) Multi paradigm: procedural, functional, object oriented, meta, reflective, generic Appeared in 1984, 1994 for ANSI Common Lisp Developer ANSI X3J13 committee Typing discipline …   Wikipedia

  • Common European Framework of Reference for Languages — The Common European Framework of Reference for Languages: Learning, Teaching, Assessment[1], abbreviated as CEFR, is a guideline used to describe achievements of learners of foreign languages across Europe and, increasingly, in other countries… …   Wikipedia

  • Common Era — BCE redirects here. For other uses, see BCE (disambiguation). Era Vulgaris redirects here. For the Queens of the Stone Age album, see Era Vulgaris (album). Common Era (sometimes Current Era[1] or Christian Era[2]), abbreviated as CE, is an… …   Wikipedia

  • table — tableless, adj. /tay beuhl/, n., v., tabled, tabling, adj. n. 1. an article of furniture consisting of a flat, slablike top supported on one or more legs or other supports: a kitchen table; an operating table; a pool table. 2. such a piece of… …   Universalium

  • Common gate — Figure 1: Basic N channel common gate circuit (neglecting biasing details); current source ID represents an active load; signal is applied at node Vin and output is taken from node Vout; output can be current or voltage In electronics, a common… …   Wikipedia

  • Control table — This simple control table directs program flow according to the value of the single input variable. Each table entry holds a possible input value to be tested for equality (implied) and a relevant subroutine to perform in the action column. The… …   Wikipedia

  • Book of Common Prayer — • Includes history and contents Catholic Encyclopedia. Kevin Knight. 2006. Book of Common Prayer     Book of Common Prayer     † …   Catholic encyclopedia

  • List of United States Marine Corps acronyms and expressions — This is a list of acronyms, expressions, euphemisms, jargon, military slang, and sayings in common or formerly common use in the United States Marine Corps. Many of the words or phrases have varying levels of acceptance among different units or… …   Wikipedia

  • Book of Common Prayer — For the novel, see A Book of Common Prayer. Part of a series on the Anglican Communion …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”