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 the command used to check locks in microsoft sql server?

0 Answers  

---

Mention the different types of replication in sql server.

0 Answers  

---

What is the difference between stored procedure and user defined functions?

0 Answers  

---

What information is maintained within the msdb database?

0 Answers  

---

How much does sql server 2016 cost?

0 Answers  

---

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---