What is CTE in Sql Server 2008?

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

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