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...

How maney row would be print after join if A table have 100
rows and B table have 50 rows...

Answer Posted / brajesh kumar srivastava

its depend on join what type join you are using,If You are
using cross join then 100*50 record would printed.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the different types of backups available in sql server? : Sql server database administration

915


What is msdb database? : SQL Server Architecture

1120


What is a view and what are its advantages?

1102


Can multiple columns be used in sql group by clause in ms sql server?

1037


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1893


What is the use of @@spid?

993


What are acid properties of transaction?

943


How many types of built in functions are there in sql server 2012?

913


how to create “alternate row colour”?

146


What is the datatype of rowid?

913


What is difference between inner join and full join?

1053


How to transfer data from a cursor to variables with a "fetch" statement?

1075


what is a deadlock? : Sql server database administration

1043


What is ddl and dml commands?

896


What is SQL Azure Firewall?

136