Can we rewrite subqueries into simple select statements or
with joins? Example?
Answer Posted / syed sajjad
Yes we can write using Common Table Expression (CTE). A Common Table Expression (CTE) is an expression that can be thought of as a temporary result set which is defined within the execution of a single SQL statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query.
|Is This Answer Correct ?||1 Yes||0 No|
System variable and temporary variables
What can be used instead of trigger?
What is the use of tempdb? What values does it hold?
tell me the disaster recovery plan
How many databases Microsoft SQL server provides?
New concepts of sql server 2005 use in your project.
How retrieve field names from the table in SQL through JAVA code?
what are the critical issues you have resloved in your company
what exactly sql injuction.how to overcome.....
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
can any body tell me how to know the password of current user in sql server
sql database suspect We have a sql database that is showing as suspect. How can we recover?
your distribution database is full what will u do