its depend on join what type join you are using,If You are using cross joi

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

Question Posted / brajesh kumar srivastava

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

Please Help Members By Posting Answers For Below Questions

Can a cursor be updated? If yes, how you can protect which columns are updated?

1033

How to download and install the scaled-down database adventureworkslt?

954

What is an indexing strategy?

947

Will the writetext statement activate a trigger?

1002

what are the three command line utilities and what are their primary functions?

136

How to select some specific rows from a table in ms sql server?

963

What is a filestream?

945

What is the name of the system variable that returns the number of rows affected by a SQL statement?

969

What are the two authentication modes in sql server?

1062

How you can minimize the deadlock situation?

983

Can we insert data into view sql server?

885

How to create a view on an existing table in ms sql server?

1054

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

916

Does sql server 2000 clustering support load balancing?

907

List the different types of collation sensitivities in sql server?

977