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

How many types of Joins in SQL Server 2005?

Question Posted / vishal

9 Answers
11885 Views
CarrizalSoft Technologies, HCL, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create a view on an existing table in ms sql server?

1105

What is factless fact table? : sql server analysis services, ssas

1005

How many types of local tables are there in sql server?

913

What are the basic functions for master, msdb, model, tempdb and resource databases?

970

Explain SSRS Architecture?

195

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

936

What is a bit datatype?

961

Which is the main third-party tool used in sql server?

924

What is join and name different type of joins?

1027

what is blocking? : Sql server database administration

1014

What are subqueries in sql server?

1095

What are cursors and when they are useful?

1070

Describe different Processing Modes offered by SSRS?

246

How to get the definition of a trigger back?

987

Do you know the cursor types?

1143