Posted by Serge Rielau on 12/15/06 20:53

Hurricane wrote:
> When I create a view in SQL and include an ORDER BY clause i can see it
> in Management Studio. However, when I call the same view from an ASP
> page the order goes completely haywire.
Good! views aren't called, they are selected from.
When you issue a SELECT it only has an ORDER if you specify it for that
SELECT.
Any order specified inside the view definition is irrelevant. Only TOP
cares for nested ORDERs

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html

• Next in forum: Re: Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition
• Prev in forum: Re: View Order Dissappearing
• Thread view: Re: View Order Dissappearing

[Reply to this message]