SQL Server Performance

row-level locking on SQL Server 2005

Discussion in 'SQL Server 2005 General Developer Questions' started by coniechan_fsktm, Jul 13, 2006.

  1. coniechan_fsktm New Member

    Hi,

    How do I do row-level locking on SQL Server 2005? pls provide sample code.

    In my application, 2 users would like to update one table simlutaneously.

    For example, 2 transactions update different rows at the same time.

    Pls advise, thank you

  2. dineshasanka Moderator

    http://www.microsoft.com/technet/prodtechnol/sql/2005/cncrrncy.mspx

    ----------------------------------------

Share This Page