Answer / divya kalra

Subqueries can often be re-written to use a standard outer
join, resulting in faster performance. As we may know, an
outer join uses the plus sign (+) operator to tell the
database to return all non-matching rows with NULL values.
Hence we combine the outer join with a NULL test in the
WHERE clause to reproduce the result set without using a
sub-query.

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

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

---

What does man by sql wildcard characters in sql server?

0 Answers  

---

What is the command used to check locks in microsoft sql server?

0 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

What is normalization according to you and explain its different levels?

0 Answers  

---

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---