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 is sub-query in sql server?

0 Answers  

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---

How to select true false based on column value in sql server?

0 Answers  

---

How much memory that we are using in Logshipping Concept?

0 Answers  

---

How to execute a sql statement using odbc_exec()?

0 Answers  

---

---

Can you name a few encryption mechanisms in sql server?

0 Answers  

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

---

What is Replication?

0 Answers  

---