What is CTE in sql server 2005?

Question Posted / manoj dagar

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

Explain about Automatic resource management?

0 Answers

What are session objects?

0 Answers

What is rich control in asp.net?

0 Answers

what is silver light when will we use silver light,

0 Answers

Finally and dispose methods?

1 Answers Microsoft,

What is the use of HttpHandlers? When to use this?

0 Answers Wipro,

How to retrieve data row by row from a DataTable? Thanks In advance PriyaPP

3 Answers

What is difference between datalist and gridview?

0 Answers

When do you set "<IDENTITY impersonate="true" />" ?

1 Answers

What is meant by web application?

0 Answers

True or False: A Web service can only be written in .NET?

5 Answers

What method do you use to explicitly kill a users session?

2 Answers Siebel Systems,

For more ASP.NET Interview Questions Click Here