Answer / g.ramesh

It produce Result Set which contains matched rows and left
table unmatched rows.

Answer / prasanna

The result set of a left outer join includes all the rows
from the left table specified in the LEFT OUTER clause, not
just the ones in which the joined columns match. When a row
in the left table has no matching rows in the right table,
the associated result set row contains null values for all
select list columns coming from the right table.

What is resource governor in sql server?

0 Answers  

---

What is extended stored procedures?

0 Answers  

---

What is the difference between truncate and delete commands?

0 Answers  

---

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

---

How to rebuild the master database?

0 Answers  

---

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

What is indexing?

0 Answers   AOL,

---

How can I get data from a database on another server?

0 Answers  

---

Explain about remote stored procedure?

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

List few advantages of stored procedure.

0 Answers  

---