Answer Posted / raji

Different Types Of JOINS:
Most of the joins you will come across are based on
equality, with the equijoin being the most dominant.
In this chapter you learned about equijoins; there are
other types of joins you must become familiar with, most
notably the self-join, the nonequijoin, and the outer join.

Equijoin or Inner Join (Equality) : Traditional comma-
separated join or ANSI JOIN syntax (including optional
INNER keyword).
Natural Join (Equality) : NATURAL JOIN keyword.
Cross-Join or Cartesian Product (No join condition):
Traditional comma-separated with the missing join condition
in the WHERE clause or CROSS JOIN keyword.
Self-Join (Equality): Equijoin or Inner Join.
Outer Join (left, right, full):(Equality and extending the
result set): "Complex Joins" OUTER JOIN keywords or outer
join operator(+).
Non-Equijoin (Nonequality of values): "Complex Joins"
Traditional comma-separated join or ANSI join syntax with
the ON clause.
The join criteria is not based on equality.

Tell about MOM Tool(Microsoft Operator Manager)?

1401

---

What were the latest updates to SQL Azure service?

92

---

What is factless fact table? : sql server analysis services, ssas

545

---

How do you make a trace?

571

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

512

---

---

What is the Difference Between Primary and Foreign Key?

575

---

Mention the differences between local and global temporary tables.

551

---

What is the difference between an index and a unique index?

536

---

What is 2nf example?

538

---

What is scrollable cursor?

534

---

What is data source object?

538

---

What is difference between inner join and full join?

535

---

What is conditional split?

529

---

What are sub reports?

149

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

637

---