SQL Server excludes an ORDER BY clause from a view to comply with the
ANSI SQL-92 standard. The only time that SQL Server supports an ORDER BY clause in a view is when it is used in conjunction with the TOP keyword. Note that the TOP keyword
is a SQL Server extension to the ANSI SQL-92 standard.
Source: http://dotnetguts.blogspot.in/2007/08/faq-on-view-in-sql-server.html
