Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / saurav kumar
Full outer join will give common + uncommon records from
both the table.
Suppose in TableA I have 5 records and TableB have 6
records. Both the table have 4 common records, means 4
records of TableA is common with TableB.
Then full outer join will give 4(common) + 1 (TableA)+ 2
(TableB) = 7 records.
Whereas Cross Join will give 5(TableA) * 6(TableB) = 30
records, also we can't put 'ON' condition with cross join.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain the cursor lock types?
How can I know what locks are running on which resource?
What causes index fragmentation?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is key attribute?
How does stuff differ from the replace function?
Can we insert data into a view?
Explain what is public role in sql server?
How is table type constraint applied to a table?
Explain the properties of subqueries in sql server?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
State the difference between local and global temporary tables?
Explain filestream storage of sql server 2008?
What are the lambda triggers?
What is ssl in sql server?
