What is CTE in sql server 2005?

Question Posted / manoj dagar

3 Answers
5975 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 routing in MVC?

0 Answers Infosys,

How to publish website

1 Answers Syntel,

how many script manager controls are used in Ajax web page?

7 Answers CSC, Health Prime Services, TCS,

How do you insert multiple rows from a grid view to database table under a single transaction?

1 Answers

What is difference between abstract class and an interface?

0 Answers

Is it necessary to create a Windows application or Web application to test a Web service ? Is it must to consume this service?

2 Answers Siebel,

what is value type to reference type

6 Answers AG Technologies, IBM,

How do I use a proxy server when invoking a web service?

0 Answers

Who will magage un-managed code?

7 Answers HP,

In the Repeater control which way you can edit?

0 Answers Siebel,

what is a .xap file? Explain with an example.

0 Answers

Differentiate session and cookie

1 Answers

For more ASP.NET Interview Questions Click Here