Posted by Erland Sommarskog on 10/01/66 11:20

Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes:
> "Erland Sommarskog" <esquel@sommarskog.se> wrote in message
> news:Xns9684F3D9BB08Yazorman@127.0.0.1...
>> In SQL 7, the 1 will be converted to a string, where as in SQL 2000
>> varcharcol will be converted to an integer. (And thus the query will
>> fail if there are values in the column that cannot be converted to
>> integer.)
>
> In addition I believe that without an order by, results returned will be
> different. (Of course the order shouldn't be specified, but I believe both
> SQL 7.0 and 2000 do default to some underlying physical order, but each
> differently from the other.)

Well, without any ORDER BY you could get different results from the
same server running SQL 7 or later depending on the phase of the moon,
availble CPUs if there are parallel streams, etc.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Appending data to a table but not duplicates
• Prev in forum: Re: SQL queries that have parameters passed by user
• Thread view: Re: MS SQL 7 and 2000

[Reply to this message]