What is CTE in sql server 2005?

Question Posted / manoj dagar

3 Answers
7203 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 asp.net web application?

0 Answers

How does asp.net page work?

0 Answers

How asynchronous call can be implemented using delegates?

0 Answers

Why session is necessary in web application?

0 Answers

What are the new features implemented in ASP.NET?

0 Answers TCS,

Any body Having SHAREPOINT Material plzzz? please material to send prasad.k12@gmail.com

0 Answers

How do you add a javascript function for a link button in a datagrid?

2 Answers Microsoft,

Which method has beenintroduced in asp.net 4.0 to redirect a page permanently?

0 Answers

By default what is the Asp.Net application login context on IIS 5.0? By default the ASP.Net app runs in the context of a local user ASPNet on IIS version 5. On IIS version 6 on windows 2003 it is called Network service

0 Answers

What is a session government?

0 Answers

What is the difference between a thread and a process?

3 Answers

When maintaining session through sql server, what is the impact of read and write operation on session objects?

0 Answers

For more ASP.NET Interview Questions Click Here