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
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How do I view a script in sql server?
How many primary keys are possible in a table?
Explain database normalization?
What is Extended user-defined?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Do you know how to make remote connection in database?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How to get all stored procedures in sql server?
How we can refresh the view?
What is the default fill factor value?
Explain intellisense for query editing
How to create new table with "create table" statements?
what are the different stages of Report Processing?
What are rows and columns?
