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

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

What are various limitations of the views?

0 Answers  

---

Why olap is used?

0 Answers  

---

Explain indexing and what are the advantages of it?

0 Answers  

---

Write query to return all rows sql?

0 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

What is a constant or literal in ms sql server?

0 Answers  

---

How would you add a section to a table?

0 Answers  

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

Does index slows down insert statements?

0 Answers  

---