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)
 How to show certain records with lock on them

Author  Topic 

rahul8346
Starting Member

21 Posts

Posted - 2006-12-01 : 01:55:03
hi Guys,
I wish to show rows of data to a user and want to not have the same row viewable to other, along other rows should be visible to other rows.
Please help in this regards.
Thanks in advance...

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-01 : 02:49:08
Your statement seems unclear at least to me
If you want to get data though locked by other users make use of NOLOCK hint. SQL server help file will give you more informations

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -