What is CTE in sql server 2005?

Question Posted / manoj dagar

3 Answers
7150 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 the significance of attaching a profile while creating a user?

0 Answers MCN Solutions,

What is difference between rest and soap?

0 Answers

How would you implement inheritance using c#?

0 Answers

How would you get asp.net running in apache web servers?

0 Answers

How to disable disable browser's Back button in asp.net (JavaScript)?

0 Answers HCL,

What is difference between masterpage and user control, what is the objective of master page when we had user control in .NET 1.1 version

3 Answers DELL, Soham,

What is localization and Globalization?

3 Answers

How Web Service help? What is the difference between Remoting & Web Servcies?

2 Answers

1. What is Connection Pooling…? 2. Maintaining Sessions in ASP.NET 3. ASP.NET page lifecycle. 4. Can we store objects in sessions. 5. What is AJAX..? 6. Serialization/Deserialization. Why we use serialization and Deserialization…? 7. What are Arrays and Arraylist..? 8. Difference between Authentication and Authorization…? 9. Difference between abstract class and Interfaces 10. What is a view..? Does a view contain data..? 11. What are triggers..? 12. What are transactions..? 13. What is Metaview (oracle)..? 14. What is Inheritance..? How can we call a method from the base class..? 15. Can an abstract class have zero abstract methods..? 16. How to read from Message Queue..? 17. What is Metadata..? 18. You would prefer to have business logic in c# or DB Side..? Why…?

1 Answers Franklin Templeton, Sky InfoTech,

What is _viewstart?

0 Answers

Suggest 3 best practices in detail for for Developing High Performance Web and Enterprise Applications

2 Answers Techno Solutions,

How do you create a permanent cookie?

2 Answers

For more ASP.NET Interview Questions Click Here