Home Forums SQL Server 2008 T-SQL (SS2K8) Best way to insert into two related tables? RE: Best way to insert into two related tables?

  • February 19, 2013 at 4:13 pm

    #1589401

    drew.allen (2/19/2013)

    Jeff Moden (2/15/2013)

    OTF (2/15/2013)

    You can also take a look at using OUTPUT.

    I've found that to be a wee bit more difficult than you would think unless you have an alternate key to reliably express the new value across the other tables.

    With that thought in mind, do you have a coded example of how to do this?

    This used to be true in SQL 2005, but it's no longer true as of SQL 2008. I'll work on writing up an article in the next few days.

    Drew

    Very cool. I'd love to see it, Drew. In fact, if you'd like, I'll be happy to do a technical review on it, if you'd like.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)