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.

What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  

---

Does a full backup include transaction log?

0 Answers  

---

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

---

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

Is foreign key unique?

0 Answers  

---

How to provide default values to function parameters?

0 Answers  

---

How to Get the last identity value used

4 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---

How do I determine how many instances of sql server are installed on a computer?

0 Answers  

---

Explain difference between cross join and full outer join?

0 Answers  

---

Does sql server use t sql?

0 Answers  

---