Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kuldeep sharma
SQL Cross Join...>Cartesian product of both tables.
Example:
Let left table has 10 rows and right table has 8 rows then
SQL CROSS Join will return 180 rows combining each record
of left table with all records of right side table.
Consider the following example of CROSS Join:
USE PUBS
SELECT AU_FNAME, AU_LNAME, PUB_NAME
FROM AUTHORS CROSS JOIN PUBLISHERS
ORDER BY AU_FNAME
Above cross join will return 23 * 8 = 184 results by
multiplying each row of authors table with publishers table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is a livelock?
What is the difference between indexing and hashing?
How you can get the list of largest tables in a database?
How to provide column names in insert statements in ms sql server?
Determine how to use the inserted and deleted pseudo tables?
What is catalog views?
What do you mean by tablesample?
How can you find out how many rows returned in a cursor?
What is indexed view? How to create it?
What is database replication? What are the different types of replication you can set up in sql server?
What is a View ? Can we insert, Update and delete a view?
How many tables can be joined in SQL Server?
What are the rendering extensions of ssrs?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
