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 maney row would be print after join if A table have 100
rows and B table have 50 rows...

Question Posted / tnt

Answer Posted / tnt

IF TWO TABLE A(100) AND B(50) ARE PARTICIPATE IN NO
SPECIFIC JOIN THEN IT WILL BE CROSS JOIN LIKE THIS

SELECT A.ROW,B.ROW FROM A,B

IT WILL GIVE 100*50 RESULT

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different index configurations a table can have?

990

What is enhanced database mirroring in sql server 2008?

1033

How to drop an existing table?

1052

what is database replication? : Sql server database administration

1129

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1076

Mention the 3 ways to get a count of the number of records in a table.

1025

Explain triggers?

1063

Explain what is meant by replication of database?

1106

Can a table be moved to different filegroup?

1025

What are different types of roles provided by ssrs?

156

How to connect of datebase with sql express.?

1144

What is the return type of executeupdate ()?

951

role of sql sever 2005 in database rather than any other database

1988

Is truncate autocommit?

993

What is resultset concur_updatable?

1053