MS SQL Server - Open View from SQL Server Management Studio

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Open View from SQL Server Management Studio

515331Jack3490

2006-10-31, 12:15 am

Why the order is lost when I Select Open View??

My query really includes an ORDER clause and the Execute query was fine.

John Bell

2006-10-31, 12:15 am

Hi

From BOL:
When ORDER BY is used in the definition of a view, inline function, derived
table, or subquery, the clause is used only to determine the rows returned by
the TOP clause. The ORDER BY clause does not guarantee ordered results when
these constructs are queried, unless ORDER BY is also specified in the query
itself.

You don't say if you are using SP1 or not, there are issues with ORDER BY
when in SQL 2000 compatibility mode.

John

"515331Jack3490" wrote:

> Why the order is lost when I Select Open View??
>
> My query really includes an ORDER clause and the Execute query was fine.
>
>
>

Sponsored Links