How many types of Joins in SQL Server 2005?

Answer Posted / mpg

There are 5 types of join in sql server 2005

inner join
outer join
cross join
equi join
self join

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is key set driven?

528


What is the maximum size of column in sql server?

501


What is 2nf normalization form?

605


Tell me about the approaches which you used to counter the DI problems.

747


What is etl - extraction, transformation, and loading?

516






What is the recursive stored procedure in sql server?

517


How to use transact-sql statements to access the database engine?

531


What is merge statement?

619


What are date and time data types in ms sql server?

517


What are the High-Availability solutions in SQL Server and differentiate them briefly?

690


What is cursors? And what are the different types of cursor?

549


Can sub report data source be different from that of the parent report?

105


What is similarity and difference between truncate and delete in sql?

579


What is the most common type of join?

520


How to check parameter value in stored procedure sql server?

454