Post reply

Transaction Handling

  • January 14, 2009 at 7:53 am

    #926572

    wow, I think this is the first question I asked on the board that didn't generate a quick reply.

    Is my question confusing? Or is there some reason nobody uses transactions in sql server 2000?

  • January 14, 2009 at 12:01 pm

    #926822

    Transactions are definitely used in SQL 2000. I personally don't have much need for transactions so I don't have a ton of experience working them, but I'd assume you'd want your logic set up basically like:

    Begin transaction inside the daddy proc.

    execute son proc. Check a return from the son proc to ensure everything happened correctly.

    If so, proceed to daughter, if not rollback the whole thing.

    Repeat for Daughter.

    Commit it both were successful.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 2 posts - 1 through 3 (of 3 total)

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