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

What is clustered vs nonclustered index?

0 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

What is standby servers? Explain types of standby servers.

0 Answers  

---

How to rename an existing column with sql server management studio?

0 Answers  

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

what are different types of raid configurations? : Sql server database administration

0 Answers  

---

Can we write ddl in trigger?

0 Answers  

---

CTE(common table expression)

1 Answers   Thomson Reuters,

---

internal language used in sql server 2000?

2 Answers  

---

How to find the second highest salary of an employee?

0 Answers  

---