Create a view with ORDER BY clause

in #sql • 4 years ago

Msg 1033, Level 15, State 1, Procedure xxxx , Line 105 [Batch Start Line 0]

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

As the error message suggested use

SELECT TOP 9999999 "fromYourQuery" ORDER BY something

#server
4 years ago in #sql by
$0.00
    Reply 0

    Coin Marketplace

    STEEM 0.19
    TRX 0.25
    JST 0.038
    BTC 97262.35
    ETH 3392.76
    USDT 1.00
    SBD 3.02