Is ORDER BY honoured in SQL Server views?

In this answer to What are the downsides of using SqlServer Views?, hyprsleepy suggests the ORDER BY clause is not honoured in views in SQL Server.

Could anyone explain why this is the case?

Edit: Thanks for the answers, but I'm not sure thats the issue. I know you cant add an Order By Clause to a view and I dont have a problem with that, you just add it to the SELECT statement when calling the view, but my impression from the other question was that using an Order By Clause in a SELECT statement on a view will not give the correct results every time.

6
задан Community 23 May 2017 в 12:21
поделиться