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 are database files and filegroups? : Sql server database administration

0 Answers  

---

How to round a numeric value to a specific precision?

0 Answers  

---

What is create command?

0 Answers  

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---

What stored by the master? : sql server database administration

0 Answers  

---

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

Explain about SQLOS?

0 Answers  

---

What are sparse columns?

0 Answers  

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

Do you know what are the restrictions that views have to follow?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---