• Paul White NZ (4/20/2010)


    CirquedeSQLeil (4/19/2010)


    ...but that is not true of an identity column, unless the identity column is a part of a Primary key.

    Or a UNIQUE constraint, as the QotD explanation says 😉

    Thanks for tidying that up:-D

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events