How to do row level locking in SQL server 2005?

Hi,
For example, there are 2 users connecting to the same table and want to
update the different rows. They are requested to use the row level locking.
Pls advise and provide the example of sql statement or sample code.
Thank youThere are several answers to this one on the SQL Server programming group.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Connie" wrote:

> Hi,
> For example, there are 2 users connecting to the same table and want to
> update the different rows. They are requested to use the row level locking
.
> Pls advise and provide the example of sql statement or sample code.
> Thank you
>
>|||You might find this article useful.
http://vyaskn.tripod.com/ row_level...as
es.htm
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Connie" <yfchan@.kdu.edu.my> wrote in message
news:uXKVV2vpGHA.2292@.TK2MSFTNGP05.phx.gbl...
> Hi,
> For example, there are 2 users connecting to the same table and want to
> update the different rows. They are requested to use the row level
> locking.
> Pls advise and provide the example of sql statement or sample code.
> Thank you
>
>