What is CTE in sql server 2005?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the namespaces used in asp.net mvc? : asp.net mvc

736


Which library is used by the testers and developers to develop automated tests and create testing tools?

768


What is dynamic web page with example?

731


How do we sort the data from a dataset?

773


How do u deploy your asp.net application?

804


Describe paging in asp.net?

892


Where is asp.net session stored?

684


Explain the path instructions in xaml?

771


What is the difference between GridView and Repeater controls in ASP.NET?

810


Which control has default post back is enabled(true)?

821


Define cookie.

761


What is difference between URL and URI?

832


What is the Intermittent crashing of application in production?

777


How do you identify that the page is postback?

734


What is state management react?

713