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

What is surrogate key? : sql server analysis services, ssas

1159

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1109

How much is a sql server license?

1009

What is the order in which the sql query is executed?

991

Explain activity monitors

1129

Define tempdb database?

1040

What is the new security features added in sql server 2016? : sql server security

1156

what are cursors? : Sql server database administration

1099

How do database indexes work?

1055

What is a recursive stored procedure in sql server?

1243

How can I check that whether automatic statistic update is enabled or not?

1092

Explain indexed views and partitioned view with their syntax.

1191

How do you identify a foreign key?

1082

How do I find sql server instance name?

1007

Do you know what are different types of replication in sql server?

1153