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

How are sessions stored?

0 Answers  


How can we make sure that Web API returns JSON data only?

0 Answers  


Explain the different types of assemblies?

0 Answers  


If we write return statement in finally block will it works fine or throws any error?

1 Answers   Patni,


What is pre-init event in ASP.NET 2.0 page life cycle?

2 Answers   Fulcrum Logic,






What is the difference between custom web user control and a custom web server control?

0 Answers  


How does a web application session work?

0 Answers  


diff between Server.Transfer() and Server.Execute()

1 Answers  


What is the difference between session and viewstate in asp.net?

0 Answers  


What is the difference between typeof() vs gettype()?

0 Answers  


Explain the difference between singleton and single call?

0 Answers  


Why is catch(Exception) almost always a bad idea?

4 Answers  


Categories