Answers were Sorted based on User's Feedback
Answer / ramesh
Full Outer Join requires a condition and related column in
Cross Join requires with out condition and no related
columns in the tables.
|Is This Answer Correct ?||5 Yes||1 No|
Answer / 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|
Answer / samba shiva reddy . m
Full Outer join it will take all the records from the both the tables.
Table1 : emp
Table2 : user
We will write the Full Outer join on both the table
Select * from emp full outer join [user] on emp.empid=[user].uid
the result will be both the tables with NULL vslues
but in the cross join it is bsed on the rows
in the cross join it will give the combination of all rows
|Is This Answer Correct ?||2 Yes||0 No|
can an order by clause be used in a creation of a view?
Can you explain what is sql server english query?
What is log shipping?
About types of indexes in SQL server ?
The Difference between 'Count' and 'Count(*)'
What's new in sql management studio for sql server? : sql server management studio
What are the advantages of using cte?
What is a scheduled job or what is a scheduled task?
If user is owning any SQL Objects, can we drop that user
Disadvantages of the indexes?
What is sql server english query?
Explain what is dbcc?