` MS SQL record locking ( Duppie ) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

Par2: MS SQL record locking
2013-01-07 -- Duppie
 
n MS SQL you need to do something like this. Wrapping your SELECT in a transaction while using WITH (XLOCK,READPAST) locking hint will get the results you want. Just make sure those other concurrent reads are NOT using WITH (NOLOCK). READPAST allows other sessions to perform the same SELECT but on other rows. BEGIN TRAN SELECT * FROM WITH (XLOCK,READPAST) WHERE RowId = @SomeId -- Do SOMETHING UPDATE SET =@somevalue WHERE RowId=@SomeId COMMIT

Today is November 21, 2024, 7:49 am
This article has been viewed 35243 times.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription