How many types of Joins in SQL Server 2005?

Answer Posted / abi

Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of keys are there?

507


What does it mean if @@cursor_row returns a negative number?

550


What is the difference between upgrade and migration in sql server?

560


Can a database be shrunk to 0 bytes, if not, why?

622


What is the difference between count () and rowcount ()?

504






How to rename databases in ms sql server?

597


How can windows applications connect to sql servers via odbc?

558


What are subqueries in sql server?

572


Mention the different types of replication in sql server.

537


How do I run a trace in sql server?

485


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

534


How you can find out if an index is useful to the optimizer?

479


What is forward - only cursors / read only cursor?

504


What is onf in normalization form?

546


What are the essential components of sql server service broker?

534