IDENTITY INSERT

  • 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

  • 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.

  • syntax seems to be wrong...

    'GO' are missing......

    Thanks.

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

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