Answer Posted / colin
A small error kuldeep..if left table has 10 rows n right
table has 8 rows..then a cross join wud return 80 rows
(10*8)..besides dis ur totally ryt.. Cross joins are also
called cartesian product..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Call by value and call by reference in procedure and function, with NOCOPY.
Where are sql server user names and passwords stored in sql server?
What is a result set object returned by mssql_query()?
What are the different authentication modes in sql server? How can it be changed?
What is partitioned view?
What are the types of database recovery models?
How does Report Builder support Analysis Services cubes?
How to insert data into an existing table?
What is the stuff and how does it differ from the replace function?
Why it is recommended to avoid referencing a floating point column in the where clause?
When I run the sql server 2000 setup, it just hangs. What do I do?
How can sql server instances be hidden? : sql server security
What do you mean by a Composite primary key?
Explain Capacity planning to create a database? and how to monitor it?