Post reply

concurrent inserts

  • June 20, 2002 at 8:40 am

    #58080

    Can I insert into 1 table from 2 concurrent transactions.

    Example: I need to insert all rows from table x into my fact table I also need to insert all rows from table z into the same fact table. Do I have to wait and run them back to back or can they load at the same time.

    -Kevin

  • June 20, 2002 at 8:48 am

    #431246

    Sorry, I already knew the answer to that is yes.

    -K

  • June 20, 2002 at 9:38 am

    #431259

    np and you are correct. SQL will manage the inserts by transaction. Works better with each version.

    Steve Jones

    steve@dkranch.net

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

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