Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Christoffer Hedgate Dealing With Changing Data RE: Dealing With Changing Data

  • December 19, 2003 at 4:55 am

    #487180

    I see that I have a slight error in the article text. The following part is not correct:

    quote:

    This means that data is locked as soon as it is read and no other user is able to read that data until the locking user releases it. The SQL Server way of doing this is of course to use Update Locks instead of Shared Locks when reading data.

    Instead, it shoud have been like this:

    This means that data is locked as soon as it is read and no other user is able to change that data until the locking user releases it. The SQL Server way of doing this is of course to use Update Locks instead of Shared Locks when reading data.

    --

    Chris Hedgate @ Extralives (http://www.extralives.com/)

    Contributor to Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)

    Articles: http://www.sqlservercentral.com/columnists/chedgate/

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/