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.

List the types of recovery model available in sql server?

869

---

How to change the password of a login name in ms sql server?

960

---

What are sql dirty pages?

969

---

How does stuff differ from the replace function?

957

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109

---

What is a not null constraint?

975

---

How to filter out duplications in the returning rows in ms sql server?

1067

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

850

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

933

---

What are different types of constraints?

875

---

Characterize join and name diverse sorts of joins?

909

---

What is indexed view? How to create it?

931

---

How to create database with physical files specified in ms sql server?

952

---

What is subquery in sql?

987

---

Explain the different types of joins?

931

---