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 happens if null values are involved in arithmetic operations?
Call by value and call by reference in procedure and function, with NOCOPY.
How to create a Master database in SQL server ?
Explain system functions or built-in functions? What are different types of system functions?
What is an execution plan? When would you use it?
What are secondary xml indexes?
Does sql server use t sql?
What is sql stored procedure?
What do you understand by sql server agent?
Tell me about builtinadministrator?
What do you mean by sql server 2005 express management tools?
Explain the difference between delete,drop and truncate in SQL Server?
What does man by sql wildcard characters in sql server?
What are horizontal and vertical scaling?
How does index makes search faster?