FK to IDENTITY

  • Excellent question with nice explanation. Keep posting

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)

  • I got it right for the wrong reason.

    I too thought that the 2nd Insert would work.

    David

  • Great question. And specifying the IDENTITY_INSERT setting for the table was definitively a good idea. Be explicit.

    Best Regards,

    Chris Büttner

  • very good one

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • Huge thanks. This was really awesum question. Though i got it correct for wrong reasons but after going through all the comments got it rectified in my mind. It really made my day. looking forward to many such QOTD. 🙂

  • interesting tricky one

Viewing 6 posts - 31 through 36 (of 36 total)

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