[dba-SQLServer] Order of data in views

Yes, I ran across this this morning in fact.  It appears to be a "bug 
fix" to cause 2005 to be like 2000.  Now the question is, is 2000's 
behavior "intentional" or is it a bug that must be emulate forever.

Not that it matters.

John W. Colby
www.ColbyConsulting.com


Martin W Reid wrote:
> John
> 
> Have you seen this
> 
> http://support.microsoft.com/kb/926292
> 
> Martin
> 
> 
> Martin WP Reid
> Information Services
> Queen's University
> Riddel Hall
> 185 Stranmillis Road
> Belfast
> BT9 5EE
> Tel : 02890974465
> Email : mwp.reid at qub.ac.uk
> ________________________________________
> From: dba-sqlserver-bounces at databaseadvisors.com [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby [jwcolby at colbyconsulting.com]
> Sent: 14 May 2008 11:12
> To: Discussion concerning MS SQL Server
> Subject: Re: [dba-SQLServer] Order of data in views
> 
> Martin,
> 
> In the end it really doesn't matter, reality is, and reality says that
> SQL treats a view as a "table".
> 
> I guess we get into semantics here.  What is a query (and to be frank, I
> certainly don't know, behind the scenes)?  Is it not a "virtual table"?
>   A set of data pulled out of the database.  WHATEVER ELSE IT IS, it is
> a SQL statement  with a SELECT clause.  Everything else that can be used
> with a SELECT clause works correct?  Why not the Order By clause?  It is
> just a steenkin SQL Statement, the ORDER BY clause should function too.
> 
> The answer to that question is probably lost in the mists of time and
> the members of some standards body who defined SQL syntax and operation
> decades ago.  Some Purist likely had some reason not to want a view
> sorted and had a LOT of pull on the committee and so here we are,
> decades later, saying "of course a view is ALWAYS unsorted".
> 
> LOGICALLY a view is a SELECT SQL statement, and the last time I looked
> SELECT SQL statements have an ORDER BY clause defined in the SQL
> syntax... but NOT if saved as a view.
> 
> Silly if you ask me.  But I don't get a vote.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> Martin W Reid wrote:
>> John
>>
>> I always treated a view as a virtual table created at the point the statement is executed. The use orderby on the statement hitting the view.
>>
>> Martin
>>
>>
>> Martin WP Reid
>> Information Services
>> Queen's University
>> Riddel Hall
>> 185 Stranmillis Road
>> Belfast
>> BT9 5EE
>> Tel : 02890974465
>> Email : mwp.reid at qub.ac.uk
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>