Adding Sorts to SQL Server Views

Total article views: 198 | Views in the last 30 days: 2

 Rate this |   Join the discussion |  Briefcase

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: 198 | Views in the last 30 days: 2