What is CTE in sql server 2005?
Answers were Sorted based on User's Feedback
Answer / santhosh khanna
Common Table Expressions, It is return temporary result set
from inside a statement.
Is This Answer Correct ? | 6 Yes | 0 No |
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 |
How are sessions stored?
How can we make sure that Web API returns JSON data only?
Explain the different types of assemblies?
If we write return statement in finally block will it works fine or throws any error?
What is pre-init event in ASP.NET 2.0 page life cycle?
What is the difference between custom web user control and a custom web server control?
How does a web application session work?
diff between Server.Transfer() and Server.Execute()
What is the difference between session and viewstate in asp.net?
What is the difference between typeof() vs gettype()?
Explain the difference between singleton and single call?
Why is catch(Exception) almost always a bad idea?