Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Row wise Lock

Author  Topic 

dsengottuvelu
Starting Member

1 Post

Posted - 2010-05-20 : 03:00:26
i have a table with four columns,if the user tries to fetch the data from this table, i need to take one random unique value from this table.

how to avoid row value if more than 1 user fetch the same row at a time.instead of fetching the same value need to fetch different values for all users.

can u give examples? using lock we can able to achieve this one ?

Sengottuvelu
   

- Advertisement -