There are 5 types of join in sql server 2005 inner join outer join cr

How many types of Joins in SQL Server 2005?

Question Posted / mpg

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

Please Help Members By Posting Answers For Below Questions

Where are sql server usernames and passwords stored in the sql server?

1041

How to create a stored procedure with a statement block in ms sql server?

985

Do you know query execution plan?

1071

Give me any three differences between Truncate and Delete.

1040

What is a domain constraint give an example?

1001

What is temporary table in sql server? Why we use temp table?

902

What is the cpu pressure?

987

What is collation sensitivity? Explain different types.

961

What is the purpose of object explorer and its features? : sql server management studio

1116

What it means to be triggered?

908

Explain the difference between delete,drop and truncate in SQL Server?

1015

Can coalesce return null?

944

Explain what are various ways to enhance the ssrs report?

989

What are the default system databases in sql server 2000?

959

What is 5nf in normalization form?

933