Post reply

Interesting BUG !!

  • June 22, 2006 at 12:18 pm

    #645341

    results are the same in SQL Server 2000 and 2K5

  • June 23, 2006 at 7:12 am

    #645523

    SELECT constid,

    id,

    colid,

    status

    error

    FROM Sysconstraints

    is the same as:

    SELECT constid,

    id,

    colid,

    status AS error

    FROM Sysconstraints

    here error is treated as the alias of column of status.

  • September 24, 2006 at 1:53 am

    #662103

    This is not a Bug...if you are using 2 field names without comma (,) sql server assumes that second field is the ALIAS name of the first field


    Philip

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

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