Results 1 to 3 of 3

Thread: Insert/Update

  1. #1
    Join Date
    Aug 2004
    Posts
    7

    Question Unanswered: Insert/Update

    Hi,
    Is it possible to Read data From a Table while Insertion/Update is happening on the table??
    In case if this is not possible,Is there anyway to do that??

    Thanks,
    Karthik

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you need accurate, dependable data, then there isn't a way to get that without waiting for the INSERT/UPDATE/DELETE transactions to finish.

    If all you need to do is browse the data, and it doesn't matter if that data is not 100% complete or accurate, then you can use either the NOLOCK index hint, or the SET TRANSACTION_ISOLATION_LEVEL command.

    -PatP

  3. #3
    Join Date
    Aug 2004
    Posts
    7
    Hi ,
    Thanks for ur suggestion.

    More inputs on this is welcome.

    Thanks,
    Karthik

Posting Permissions

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