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
Explain the use of keyword with encryption. Create a store procedure with encryption?
How to get a list of all tables with "sys.tables" view in ms sql server?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Explain the difference between HTTP and HTTPS in database?
How to convert binary strings into integers in ms sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is sharding?
What is sql server replication? : sql server replication
What happens when converting big values to numeric data types?
How to verify the port number of the sql server?
What is filter index?
How to select some specific columns from a table in a query in ms sql server?
How to modify the underlying query of an existing view?
Explain about local stored procedure?
What is tempdb database? : SQL Server Architecture