Answer / g.ramesh

It produce Result Set which contains matched rows and left
table unmatched rows.

Answer / prasanna

The result set of a left outer join includes all the rows
from the left table specified in the LEFT OUTER clause, not
just the ones in which the joined columns match. When a row
in the left table has no matching rows in the right table,
the associated result set row contains null values for all
select list columns coming from the right table.

What are the advantages of passing name-value pairs as parameters?

0 Answers  

---

Explain what is the difference between union and union all?

0 Answers  

---

Explain system views?

0 Answers  

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

---

---

What is the largest component inside a field?

0 Answers  

---

How do I debug a stored procedure in sql server?

0 Answers  

---

what is the cursor life span?

5 Answers   Evalueserve, HG,

---

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

---

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

---

How do I find the size of a sql server database?

0 Answers  

---

Can two tables share a primary key?

0 Answers  

---