Answer / g.ramesh

It produce Result Set which contains matched rows and both
side tables unmatched rows.

Answer / pushpa

Join interms of database combining two or more tables.
we have many joins.
inner join,self join,outer join,cross join.
in outerjoin we have three types.
left outer join
right outer join
full outer join
if we want to join two tables--
use left outer join- get the matched columns of two tables & ramaining columns of left hand side table of the join statement.

use right outer join- get the matched columns of two tables & ramaining columns of right hand side table of the join statement.

use full outer join- get the matched columns of two tables & ramaining columns of left hand side table and right hand side table of the join statement.

Answer / naren

matching columns of left and right tables and unmatched columns of both tables is displayed.

What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  

---

What is database architecture? : SQL Server Architecture

0 Answers  

---

What are the different types of Indexes available in SQL Server?

0 Answers  

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

Can we insert data into a view?

0 Answers  

---

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

---

Explain cursor as data base object?

0 Answers  

---

What is model database? : SQL Server Architecture

0 Answers  

---