Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    11

    Unanswered: Concurrency issues in stored procedures

    I have a question regarding concurrency in stored procedures. I have a stored procedure with the following flow of control:

    -- A couple of select statements here.

    -- (placeholder - see below)

    -- A couple of updates based on the data obtained
    -- from the above select statements.


    I'm concerned that while the stored procedure is running, if right when it gets to the spot in the code marked 'placeholder', the scheduling mechanism of SQL Server switches to another thread that contains requests from another client which makes changesto the data in the previous select statements. This will make my updates bad, since they rely on data (from the select statements)that has been modified.

    I guess I'm curious what I would need to do to lock the records in the select statements until after my update statements are completed. Thanks in advance for any advice!

    Everett
    Last edited by Ev Conrad; 06-06-02 at 19:05.
    Everett

  2. #2
    Join Date
    Feb 2002
    Posts
    11
    Bump
    Everett

Posting Permissions

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