Answer Posted / 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 the filtered index?

1065

---

What is the latest version of microsoft sql server?

1051

---

How do you size a resultset?

920

---

What are sql dirty pages?

1031

---

What are the limitations/drawbacks or ssrs 2008 r2?

139

---

How to connect sql server management studio express to sql server 2005 express?

1049

---

What are the transaction properties?

1025

---

What are the different subsets of sql?

1554

---

How do you know if sql server is running on your local system?

1046

---

What do you need to connect php to sql server?

1111

---

What are various aggregate functions that are available?

990

---

In which sql server version report builder introduced?

150

---

Explain table valued parameters in sql server? Why tvp used?

1024

---

Explain what is cte (common table expression)?

1136

---

Explain what is log shipping?

1141

---