What is CTE in sql server 2005?

Question Posted / manoj dagar

3 Answers
7206 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 are sessions stored?

0 Answers

What is the use of response redirect in asp.net?

0 Answers

In which form does the dataset store data in it?

3 Answers Verinon Technology Solutions,

What is the application pool?

0 Answers

What is advantage of viewstate and what are benefits ?

1 Answers

In order to bind the data from a data source to the Repeater control what property is set and what method must you call in your code,?

0 Answers Siebel,

How do you implement Paging in .Net ?

1 Answers

What are sql joins?

0 Answers

With example & diagram explain AutoPostBack.

2 Answers

In Data grid the question is below quantity price total these are 3 fields available in data grid if you enter quantity the total has to update automatically.Price field is already filled completely

0 Answers Quest,

I have been asked in an interview What is your LOC(Line of Code)What will be the probable answer for that

1 Answers HCL, Infosys, Mantec Consultants,

how to do pakaging nd deployment

1 Answers

For more ASP.NET Interview Questions Click Here