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...
- 9 Answers
- 11809 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / gopi muluka
My answer above assumes there are no common columns between
two table, in that case answer would be 5000 rows.
Otherwise Interviewer never mention about number of rows in
each table, If he is only interested in knowing what is the
default Join?
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Which table keeps information about stored procedures?
What is difference between rownum and row_number?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How do you make a trace?
What do you mean by normalisation?
What is difference between delete & truncate commands?
How do you start single user mode in clustered installations?
What it means to be triggered?
What are the recovery models in sql server 2000?
How do clustered indexes store data?
What is a heap?
What is temporal table?
When I run the sql server 2000 setup, it just hangs. What do I do?
What is attribute relationships, why we need it? : sql server analysis services, ssas
