IF TWO TABLE A(100) AND B(50) ARE PARTICIPATE IN NO SPECIFIC JOIN THEN IT

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

Question Posted / tnt

9 Answers
11746 Views
Hewitt, I also Faced
E-Mail Answers

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

How do you troubleshoot errors in a SQL Server Agent Job?

1049

Explain in brief how sql server enhances scalability of the database system?

975

What is the purpose of sql profiler in sql server?

1012

Can you please explain the difference between primary keys and foreign keys?

1099

Does windows server 2016 come with sql server?

925

Explain index in sql server?

1009

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1017

What is the difference between count () and rowcount ()?

1016

Explain go command in sql server?

1028

Define compound operators?

905

Do you know how to store and query spatial data?

1034

What are the main differences between #temp tables and @table variables and which one is preferred?

1076

Why are you getting errors when creating a new odbc dsn?

1213

What is merge join?

1191

What is dbcc command in sql server?

1083