Hmm, not sure I can explain this behaviour but how are you creating (and what it actually is) "index value"?

If it is some number I suggest to use sequence instead...

TOP also is SQL Server specific construction and not allowed in Oracle.

Yep the problem is "it seems so". I don't like the word "seems". I would like to find exact place in docs where it is written.

In official description about "contains"...

See also

Difference between predicates in ON clause vs. predicates in WHERE clause

with description how outer joins theoretically are created.

As soon as SQL Server will implement full windowing clause (including sliding...

For more info about SQL set operators read this.

Suppose I have interval from 100 days back till today (sysdate).

The query then is as follows:

SQL> select to_char(sysdate - rownum, 'D'), count(*)

2 from dual

3 ...

Just a small addition for:

"I've heard various answers, but the answer given by one of the panelists, that there hasn't been a widespread adoption of RAC, so why should Microsoft...

At least it is not in SQL Server docs

http://msdn.microsoft.com/en-us/library/ms177634(SQL.90).aspx

The outer join operators (*= and =*) are...

LEFT JOIN and RIGHT JOIN are completely the same, if tables are switched.

Just the same for *= and =* in case the columns/variables/constants are switched for the old syntax.

Jeff Moden (2/16/2009)

---

It's a GREAT day for arguments! :P...

Perry Whittle (2/16/2009)

---

Jeff Moden (2/15/2009)

---

Heh... that's one man's opinion. Anything that won't even allow for more than a 30 character object name certainly isn't the most flexible of the...

At least on 2006 the business chose Oracle 😉

Cannot find anything...

There is difference between join condition and where condition for outer joins. Briefly if join condition is not satisfied then rows from base table are kept and values for outer...

jgrubb (2/12/2009)

Wow. That page is wildly wrong in many cases. It's written by an Oracle User group, and really doesn't know all SQL Servers capabilities, and...