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

How is foreign key related to primary key?

578


What are indexes in ms sql server?

556


Explain partitioned view?

593


Sql server reporting services vs. Crystal reports.

96


Explain what are the authentication modes in sql server?

502






What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

593


Do you have any idea about the tcl commands?

557


what is difference between view and Dip.

2003


Why do you need a sql server?

510


Explain about nested stored procedure?

608


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

1635


tell me the disaster recovery plan

2031


What does asynchronous call backs means?

625


What is the library index called?

596


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.

1379