What is CTE in sql server 2005?

Answer Posted / ankit verma

A common table expression (CTE) can be thought of as a
temporary result set that is defined within the execution
scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE
VIEW statement.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a web based system?

737


What is _viewstart?

717


Explain how can we inherit a static variable?

798


What is difference between or and orelse?

766


Which is better viewstate or session?

732


Explain server control extensibility with reference to asp.net 2.0 ?

766


How to find out what version of asp.net I am using on my machine?

830


What is http pipeline in asp.net?

740


What is the default authentication mode for asp.net?

834


Explain how is the asp.net mvc architecture different from others? : asp.net mvc

754


how to transfer the file from client to server using asp.net

849


How can you pass multiple complex types in Web API?

794


Explain code snippet to register exception filters from controller?

844


How do you declare static variable? What is its lifetime?

755


What is server side in asp.net?

750