What is CTE in sql server 2005?

Question Posted / manoj dagar

3 Answers
7298 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

how can i insert array values and retreive in asp.net

3 Answers TCS, Value Labs,

How do you handle session management in ASP.NET and How do you implement them. How do you handle in case of SQLServer mode?

1 Answers DELL, Microsoft,

what is code access security,role based security explain with example

1 Answers Infosys,

why we should use more than one web.config files in our application? I have two web.config files in my application. One in the root directory and another one inside a sub folder. When the application runs which web.config file will run? why?

1 Answers

How do you handle unhandled exceptions in ASP.NET?.

3 Answers

How many webforms are possible on a single webpage?

6 Answers

What are HTTP handlers in ASP.NET?

0 Answers MindCracker,

Explain how asp.net different from asp?

0 Answers

asp.net page is a object or not?

5 Answers

Which is the parent class of the web server control?