Post reply

FK to IDENTITY

  • April 27, 2013 at 6:44 am

    #1610594

    Excellent question with nice explanation. Keep posting

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

  • April 27, 2013 at 5:15 pm

    #1610620

    I got it right for the wrong reason.

    I too thought that the 2nd Insert would work.

    David

  • April 29, 2013 at 1:13 am

    #1610687

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

    Best Regards,

    Chris Büttner

  • April 30, 2013 at 12:38 am

    #1611128

    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] 😉

  • May 8, 2013 at 2:16 am

    #1613233

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

  • May 31, 2013 at 1:29 am

    #1619971

    interesting tricky one

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

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