Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How many types of Joins in SQL Server 2005?

Question Posted / prasanna

Answer Posted / prasanna

1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create function without parameter in sql server?

1036

Why is the need for data conversion transformations?

1030

What is the difference between Triggers and Stored Procedure?

1075

what authentication modes does sql server support? : Sql server database administration

1068

What is use of @@ spid in sql server?

1194

Can we join two tables without primary key?

1019

Explain logical operators in sql server?

1086

If any stored procedure is encrypted, then can we see its definition in activity monitor?

964

What are “unrepeatable reads”?

1211

How will you find out if there are expensive SQL statements running or not?

996

What are the different SQL Server Versions you have worked on?

987

How to concatenate two strings in SQL Server.

1133

What is the difference between count and distinct count?

868

What do you mean by tablesample?

1063

What is meant by indexing?

990