The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries

Error Message:
Msg 1033, Level 15, State 1, Line 5
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

Severity level:
15.

Description:
This error message appears, when you try to call one of the above mentioned constructs without specifying also TOP or FOR XML.

Consequences:
The SQL statement cannot be parsed and further execution is stopped.

Resolution:
Error of the Severity Level 15 are generated by the user and can be fixed by the SQL Server user. You must add the TOP or FOR XML clause to the statement.

Versions:
All versions of SQL Server.

Example(s):
SELECT *
  FROM
 (SELECT *
    FROM Northwind.dbo.Orders
   ORDER BY OrderID)

Remarks:
In the above example the derived table is queried without the use of TOP or FOR XML. This raises the error.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |