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.

How to create sub reports?

192

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

503

---

What are data driven subscriptions?

79

---

What is the difference function and stored procedure?

560

---

Explain different forms of normalization?

524

---

---

How to provide column names in insert statements in ms sql server?

599

---

What is dbcc updateusage?

534

---

what is denormalization? : Sql server database administration

471

---

What is a schema in ms sql server 2005?

560

---

What is the xml datatype?

619

---

Can we use having clause without group by?

549

---

What are horizontal and vertical scaling?

144

---

Is the order of columns in the set clause important in ms sql server?

515

---

What are logical/boolean operations in ms sql server?

537

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

499

---