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.

What are sub reports?

208

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1028

---

What is b tree index?

963

---

How would you add a section to a table?

1106

---

What is Cross Join and in which scenario do we use Cross Join?

1057

---

Explain differentiate between a having clause and a where clause?

949

---

What are the properties and different types of sub-queries?

1046

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1084

---

Tell me what is log shipping?

1029

---

What are .mdf files?

1012

---

Explain the purpose of indexes?

1016

---

Define full outer join in sql server joins?

1045

---

Can you explain what is the use of custom fields in report?

1099

---

List the different index configurations possible for a table?

975

---

What is the difference between varchar and nvarchar datatypes?

1137

---