|
Posted by David Portas on 12/15/06 20:52
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.
>
>
> Any ideas?
Views are unordered by definition. ORDER BY is useful in a view only to
define the subset of rows to be selected by the TOP clause - it doesn't
affect the expected ordering of a query against the view.
The right way to do it is to add ORDER BY to the SELECT statement that
queries the view.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|