What is Left Outer Join?

Answer Posted / g.ramesh

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

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a user to access a database in ms sql server using "create user" statements?

510


How to drop existing indexes in ms sql server?

574


What is the difference between a fill factor of 100 and 0?

519


Ms sql server index?

519


What are sparse columns?

576






You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

607


How do I run a trace in sql server?

489


What is an example of a foreign key?

499


What is SQL Server?

654


Explain about nested stored procedure?

592


What are the 2 types of classifications of constraints in the sql server?

576


Explain syntax for viewing trigger?

529


What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

568


what are different types of backups available in sql server? : Sql server database administration

486


What is the difference between osql and query analyzer?

533