|
Posted by Alexander Kuznetsov on 10/02/91 11:47
> With an ORDER BY the result > set is identical.
Can you post versions of SQL Server and Oracle and operating systems
for which they are identical?
In fact it is a well known little obstacle in migrations between
Oracle and SQL Server. More to the point, immediately before posting I
ran the script and cut and pasted my results. Repeat, the results as
harvested from 2 live servers several hours ago are different:
SELECT * FROM T1 order by c1;
SQL Server:
c1
----------
A_A
AAA
(2 row(s) affected)
drop table t1;
The same script in Oracle running on UNIX (HP-UX) returns rows in a
different
order:
C1
----------
AAA
A_A
Navigation:
[Reply to this message]
|