Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

Define Common table expression (CTE) in SQL Server

Feb 19 2012 12:00AM by Vivek Johari   

Question

Define Common table expression (CTE) in SQL Server

Answer

Common table expression or CTE can be described as the temporary, named record set return by the execution of the query (insert, delete, update, select or update view statement). It is not stored as an object in the database and it last only till the execution of the SQL Query. It also can reference itself. It can be referenced multiple times.

The Common table expression has the following syntax:

With Expressionname (Column list) AS ( CTE query definition )

Here, Expressionname is the name of the CTE, Column list is the name of the unique column names which are return as the record set through the execution of the CTE query and CTE query definition is the SQL query which we are going to use in the CTE.

Read More..   [110 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  · 


Vivek Johari
116 · 1% · 445
0
Liked
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"Define Common table expression (CTE) in SQL Server" rated 5 out of 5 by 5 readers
Define Common table expression (CTE) in SQL Server , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]