Posted by Tony Rogerson on 01/31/06 14:19

A better method --->

R T F M

I'll let you work out the letters for yourself.

You should always read the product specs for features you need to use, that
is the same in the standard and also the same for vendor features.

The changes from 6.5 to 7.0 where fully documented, there is a compatibility
level if you want to get the behaviour back; although not recomended but it
does give you time to modify your application.

Can the true be same of the ANSI standard? What happens when items are
discontinued? You are stuffed, worse still - you get NO warning!

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1138670415.669208.42200@g49g2000cwa.googlegroups.com...
>>> I never knew that ordering a view was unsupported. It always has
>>> worked, I bet it always will, but it is good to know. <<
>
> Not the way to bet. Are you old enough to remember when GROUP BY did a
> sort and T-SQL dialect-only programmers wrote code that depended on
> that single-processor sort model? Things blew up after 6.5 because
> they wanted to save a few keystrokes and to violate standards (or as I
> call it "Speaking Hillbilly SQL").
>
> The advantage of following standards is that you can escape the
> contigous files/ contigous records physical model for MUCH better
> implementations, parallelism, etc.
>

[Back to original message]