Posted by Erland Sommarskog on 01/31/06 00:53

Doug (drmiller100@hotmail.com) writes:
> huh. I never knew that ordering a view was unsupported. It always has
> worked, I bet it always will, but it is good to know.

Some people have found that "always" does not include SQL 2005.

> OTOH, if you take the EXACT same code, stuff it into a stored
> procedure, it is guaranteed to work.
>
> yet another reason not ot use views.

Yep!


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server does not exist or access denied
• Prev in forum: Re: T-SQL ROUND(decimal, int) vs C# Round(Decimal, Int32)
• Thread view: Re: ORDER BY in VIEW not working

[Reply to this message]