• Sergiy (5/24/2013)


    GilaMonster (5/24/2013)


    I never claimed or stated anywhere that it has any effect on the insert

    Look, just 1 row above you say:

    the select portion of an insert statement

    If anything has an effect on the part than it mast have an effect of the whole.

    I never claimed it had an effect, on the whole or the part, in that statement or any other. I stated it is valid, that is, it parses successfully.

    So, at least one of your statements is wrong.

    Except I never made such a statement. If you want to claim I said something I never did, please, by all means carry on, have fun.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass