Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Unanswered: commit after 10000 rows

    Hi
    I need to update a vary large amount of records (3 million). I don't want to wait till the end of the update to commit.
    do you know how can I commit the transaction after, lets say 10000 rows, and then continue to the next 10000... and so on ?
    I think it's one of the SET commands but I can't remember it.

  2. #2
    Join Date
    Oct 2003
    Location
    Suzhou, China
    Posts
    4

    Re: commit after 10000 rows

    set rowcount 10000

    while (still have records to be updated)
    begin
    update records
    end

    set rowcount 0

    Originally posted by aig
    Hi
    I need to update a vary large amount of records (3 million). I don't want to wait till the end of the update to commit.
    do you know how can I commit the transaction after, lets say 10000 rows, and then continue to the next 10000... and so on ?
    I think it's one of the SET commands but I can't remember it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •