1. Inner Join 2. Outer Join - Left Outer Join

How many types of Joins in SQL Server 2005?

Question Posted / vishal

Answer Posted / vishal

1. Inner Join
2. Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
3. Cross Join

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain concepts of analysis services?

963

Explain what is sql server english query?

1051

Explain different types of self contained sub query?

1041

What is difference between equi join and natural join?

1041

Which rendering formats are affected by the pagesize properties?

144

Why use “nolock” in sql server?

1059

How we can compare two database data?

948

How to create an identity column?

1222

What is the default server name for sql server?

1171

How do you test your database? : sql server database administration

1023

What is Replication?

1052

Can a cursor be updated? If yes, how you can protect which columns are updated?

1111

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1064

What is the process of normalising?

998

What do you mean by an execution plan? Why is it used?

1027