What is CTE in Sql Server 2008?

 Posted by Sumank on 5/17/2013 | Category: Sql Server Interview questions | Views: 2503 | Points: 40
Answer:

CTE is an abbreviation Common Table Expression. A Common Table Expression (CTE) is an expression that can be thought of as a temporary result set which is defined within the execution of a single SQL statement. 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.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response