Re: ORDER BY in VIEW not working
- From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
- Date: 7 Mar 2006 01:27:38 -0800
RickW wrote:
I'm a
bit ticked that a very useful feature, in place for almost a decade, was
taken away without more reasonable notice. I would have thought it
would show up on the MSDN page I quoted in an earlier reply.
Your unwillingness to learn is so amazing that I wonder why you
bothered to ask at all. There was no notice in the docs because no
feature was removed. It's just that you assumed the existence of a
feature that never was there. Even in SQL Server 2000 queries against
views containing ORDER BY don't always respect any predetermined order.
In many cases ORDER BY in views will be ignored. I believe that has
been true of every version of SQL Server. Your elementary mistake
reminds me of the joke about the economist who sees a brown cow and
therefore assumes all cows are brown.
I'd second Joe's suggestion: get some training. Trial and error is the
most expensive form of education.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
.
- References:
- Re: ORDER BY in VIEW not working
- From: --CELKO--
- Re: ORDER BY in VIEW not working
- From: RickW
- Re: ORDER BY in VIEW not working
- Prev by Date: Special characters in MSSQL.
- Next by Date: Re: Special characters in MSSQL.
- Previous by thread: Re: ORDER BY in VIEW not working
- Next by thread: Re: ORDER BY in VIEW not working
- Index(es):
Relevant Pages
|
