Post reply

Problems in ORDER By

  • August 7, 2008 at 12:04 am

    #195354

    I am not able to get the result set for Order by in sql server 2005 as i get in sql server 2000

    its throwing constant expression cannot be included in sql server 2005 order by

    is that not backward compatible

  • August 7, 2008 at 12:34 am

    #854226

    pls post the query.

    from BOL - " A sort column can include an expression, but when the database is in SQL Server 2005 (90) compatibility mode the expression cannot resolve to a constant."

    "Keep Trying"

  • August 7, 2008 at 1:36 am

    #854243

    mariyappa (8/7/2008)

    I am not able to get the result set for Order by in sql server 2005 as i get in sql server 2000

    its throwing constant expression cannot be included in sql server 2005 order by

    is that not backward compatible

    Can you post you query? I don't see any reasons to have only constant expression in the order by clause to generate column/alias position at runtime. If you check execution plan, order by cluase is ignored if it only contians constant expressions.

    Regards
    Shrikant Kulkarni

  • August 12, 2008 at 12:11 pm

    #856949

    Please post the uery

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply