Prev: SQLjobvis 3.0 (free) - Visualize your SQL agent job histories...
Next: [SS 2000] Mirroring of only 1 table
From: Gerry Hickman on 4 Mar 2010 08:54
"Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote in
message news:emq52k5uKHA.5936(a)TK2MSFTNGP04.phx.gbl...
> http://sqlblog.com/blogs/tibor_karaszi/archive/2007/11/28/sorted-views.aspx

Thanks Tibor, there's a lot of explanation in this blog.

> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi

From: Plamen Ratchev on 4 Mar 2010 10:02
In addition to the other comments, BOL has this explained very well:
http://msdn.microsoft.com/en-us/library/ms187956.aspx

The ORDER BY clause is used only to determine the rows that are returned by the TOP clause in the view definition. The
ORDER BY clause does not guarantee ordered results when the view is queried, unless ORDER BY is also specified in the
query itself.

--
Plamen Ratchev
http://www.SQLStudio.com
First  |  Prev  | 
Pages: 1 2
Prev: SQLjobvis 3.0 (free) - Visualize your SQL agent job histories...
Next: [SS 2000] Mirroring of only 1 table