Answers were Sorted based on User's Feedback
Answer / g.ramesh
It produce Result Set which contains matched rows and left
table unmatched rows.
|Is This Answer Correct ?||3 Yes||2 No|
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.
|Is This Answer Correct ?||0 Yes||1 No|
What are the authentication modes in sql server? How can it be changed?
What are the purposes and advantages stored procedure?
Explain filestream storage of sql server 2008?
How many instances per computer are there in sql server 2000?
Explain the properties of sub-query in sql server?
What is dbcc? Give few examples.
What are four major operators that can be used to combine conditions on a where clause?
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ email@example.com
What is RMS migrations?
Can we add an identity column to decimal datatype?
how we use window authentication connection with sql server.?
How to find the list of fixed hard drive and free space on server?