Answer Posted / ramesh
A join with out condition is called CrossJoin.
It also called as cartesionjoin.
It produces resultset where every row is first table joined
with every row in second table.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the database objects? : SQL Server Architecture
What is log shipping?
Define outer join?
Can a unique index be created on a column, which contains null?
What is the default order of an order by clause?
Explain transaction server explicit transaction?
What is a mixed extent?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What is conditional split?
Define cursor locking
Explain trigger and trigger types?
What is the difference between cartesian product and cross join?
Why use “pivot” in sql server?
How do you create a clustered index?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
