Answer Posted / j.jyothy

Already i explained 3 joins now i tell u Outerjoins.
leftouterjoin:It will display all the rows of left table
irrespective of whether there is a match in the right or
not.If there is no match in the right table then the null
row is aasumed and it is displayed in the output.

Display all emps in the emptable.
select empno,ename,esal,e.deptno,d.deptno,dname,loc from
emp e left outerjoin dept d on e.deptno=d.deptno

RightOuterJoin:It will display all the rows of right table
irrespective of whether there is a match in the right or
not.If there is no match in the Left table then the null
row is aasumed and it is displayed in the output

Example
select empno,ename,esal,e.deptno,d.deptno,dname,loc from
emp e right outerjoin dept d on e.deptno=d.deptno

What are the different authentication modes in sql server? How can it be changed?

1095

---

How to create hyperlink from returned sql query ?

1129

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

973

---

What are the purpose of Normalisation?

1051

---

What is single-user mode?

946

---

What is dimension table? : sql server analysis services, ssas

1024

---

How to use transact-sql statements to access the database engine?

1069

---

When columns are added to existing tables, what do they initially contain?

1036

---

What is the recovery model?

992

---

Is sql different from sql server?

1094

---

What type of locking occurs during the snapshot generation? : sql server replication

1333

---

Differentiate sql server reporting services vs. Crystal reports?

203

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1065

---

What are the different types of lock modes in sql server 2000?

949

---

what's sql server? : Sql server database administration

1001

---