Answer / g.ramesh

It produce Result Set Which contains matched rows and right
table unmatched rows.

Answer / ram

select empno,ename,sal,e.deptno,dname from emp e right outer
join dept d where e.deptno=d.deptno

in abvoe query we use emp and dept table with right outer join
which produce output all records from dept table and
matched records from emp table

Can you tell me about the concept of ER diagrams?

0 Answers  

---

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

tell me the disaster recovery plan

0 Answers   Microsoft,

---

If no size is defined while creating the database, what size will the database have?

0 Answers  

---

---

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

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

What are subquery and its properties?

0 Answers  

---

What is the process of normalising?

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

Which is the main third-party tool used in sql server?

0 Answers  

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---