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
How you can minimize the deadlock situation?
How do database indexes work?
How to encrypt data between dialogs?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain nested join?
what is a transaction? : Sql server database administration
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Explain the steps needed to create a scheduled job?
What stored by the tempdb ? : sql server database administration
What are policy management terms?
optimization techinques
what is package and it uses and how can u call a package
What is an example of a primary key?
What is a functions and types in sql server?
What is transaction server explicit transaction?