IDENTITY INSERT

  • SQLRNNR

    SSC Guru

    Points: 281252

    Thanks for the question.

    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

  • JChrisCompton

    SSCommitted

    Points: 1533

    Good question.

    #2 fooled me - I didn't notice the table name was missing, and I wasn't familiar with DEFAULT VALUES as valid data - can't see myself using it but it is still good to know.

  • SQL_Hunt

    SSC-Dedicated

    Points: 33450

    syntax seems to be wrong...

    'GO' are missing......

    Thanks.

Viewing 3 posts - 31 through 33 (of 33 total)

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