[dba-SQLServer] Views don't sort

So something like:

Create View vwSomeView AS
Select TOP 99.9999 percent Field1, Field2, Field3
>From tblSomeTable
Order by Field3

does not sort field3?  what are your results when you just select * from
vwSomeView ?  are the results sorted in your results display in management
studio?


-Francisco
<http://bit.ly/sqlthis>



On Fri, May 20, 2011 at 10:02 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> One of the things I am trying to do is use SQL Server to speed up my
> applications.  The theory is that I can hand off the heavy lifting to SQL
> Server and just get back result sets.  Of course this works in terms of
> joins and filters in a view, but even though I specify a sort in a view,
> when the result set hits the other end (Access in my case) it is unsorted.
>
> Views have the ability to do sorts, so why is the data returned by a view
> into a third party app, or even into another view in SQL Server unsorted?
>  Is there a way to tell sql server to return sorted data?
>
>
>