Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Adding Sorts to SQL Server Views

By iecdba,

Microsoft says that you cannot add an ORDER BY to a view unless it comes with a TOP clause at the beginning of the query. Many people think that if that's true then you cannot "Order" the whole query but only the top few. However, this is not true because when you use TOP 100 PERCENT with the query you can ORDER BY the whole result set inside the view definition, like this (I tested this on a NT4 workstation and on NT4 server SP6, with SQL Server versions 7 and 2000):

Total article views: 228 | Views in the last 30 days: 1
 
Related Articles
FORUM

Query performance for Ordering

Query performance for Ordering

FORUM

query execution order

query execution order

FORUM

Query Order

while run the query the order of data will be different in every run.

FORUM

order by ??

Order by Query

BLOG

SQL Query Result Order

Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned i...

Tags
miscellaneous    
t-sql    
 
Contribute