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.

Describe in brief authentication modes in sql server.

0 Answers  

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

What is the difference between char, varchar and nvarchar?

0 Answers  

---

What are the results of running this script?

0 Answers  

---

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---

Explain what is row_number function?

0 Answers  

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

How you can move data or databases between servers and databases in sql server?

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

How can a user-defined datatype be created?

0 Answers  

---

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

---