What is CTE in sql server 2005?

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

Will the asp.net validators run in server side or client side?

0 Answers  


Where is session data stored in asp net?

0 Answers  


List some of the important session state modes of asp.net.

0 Answers  


Why does a user need nothing more than a Web browser to view ASP.NET pages?

1 Answers  


what is the difference between this.controls and page.form1.controls and me.controls?

2 Answers   FactorH,


What is a web api? Which protocol is used in a web api?

0 Answers  


Explain the difference between dataset and datareader.

0 Answers  


Fetch one page value to another page without using state-managment ?

0 Answers   HCL,


Explain what the contents of cookie?

0 Answers  


What are the event handlers that we can have in global.asax file?

0 Answers  


Types of exceptions in dot net???

1 Answers   TCS,


What is the difference between a page theme and a global theme?

0 Answers  


Categories