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 the difference between a candidate key and primary key?

524


What is the difference between server-side scripting and client-side scripting?

551


Explain the concept of MVC Scaffolding?

593


How can you use a custom controls in ASP.NET application?

552


Define web services in asp.net.

560






What are server activated objects?

635


What is the difference between Classic ASP and ASP.Net?

533


What are the data controls available in asp.net?

508


What is the difference between the asp and asp.net?

491


If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?

572


Define a static class?

533


What are the Types of authentications in IIS

599


Explain the difference between server.transfer and response.redirect? Why would I choose one over the other?

544


What are strong names?

587


What are the advantages of using Master Pages?

603