What is CTE in sql server 2005?

Question Posted / manoj dagar

3 Answers
5979 Views
Minecode, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is CTE in sql server 2005?..

Answer / santhosh khanna

Common Table Expressions, It is return temporary result set
from inside a statement.

Is This Answer Correct ?

6 Yes

0 No

What is CTE in sql server 2005?..

Answer / 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

What is CTE in sql server 2005?..

Answer / monalik

CTE means Common table Expression in SQL 2005
This new feature is provided in sql 2005 for
writing recursive query.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer

More ASP.NET Interview Questions

What is the Web.config file used for? a) To store the global information and variable definition for the application. b) Configures the time that the server-side codebehind module is called c) To Configure the Web Server. d) To Configure the Web browser.

8 Answers HCL, IBM, Syntax Softtech, Vypin, WideVision Technologies,

What is smart navigation?

1 Answers

Where would you use an iHTTPModule, and what are the limitations of any approach you might take in implementing one

1 Answers

What is meant by role based security? when we use this one

2 Answers

What is the Global.asax used for?

9 Answers

What are the different types of sessions in asp.net? Name them?

0 Answers

How does the cookies work in asp.net?