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 are constraints? : Sql server database administration

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

Is the primary key column of a table an index in ms sql server?

0 Answers  

---

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

---

Which are the olap features?

0 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

what is maximum size of temp db?

4 Answers   iSoft,

---

What is the difference between createstatement and preparedstatement?

0 Answers  

---

What is clustered primary key?

0 Answers  

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

---