What is the difference between cross join and Full outer
join?
Answer / soma shaw
A cross join is a Cartesian join. for sets of A and B rows, you'll get a result of A * B rows. A full join will match all possible rows, meaning it will return AT MOST A + B rows.
Is This Answer Correct ? | 18 Yes | 0 No |
How do you find the error, how can you know the number of rows effected by last SQL statement?
What is the purpose of forms?
Advantages and disadvantages of stored procedures.
What is the difference between executequery () and executeupdate ()?
What is inner join in sql server joins?
What are the recovery models in sql server 2000?
What are the advantages of mirroring?
How to throw custom exception in Stored Procedure?
What is executereader?
How you can get the list of largest tables in a database?
Differentiate between mongodb vs. Sql server?
Which institute is best for SQL Server 2005 Training?