I'm trying to put an update query (NOLOCK) on:
UPDATE ( Nolock) with pth_patchLookup SET ScanDateTime = Getdate () where RegID = 312
but I get the following message:
NoLock signal supported only with selected Is not included with the statement and update, insert and delete
Is there a way in which I can apply 'Nalokak' to this update query?
Thanks for any help
(NOLOCK)
disables unlock lock and not exclusive lock. You can read the level of isolation committed to open a special place, lock on select statements.
Update SET Translation ASSOCIATION LEVEL READ COMMITED pth_patchLookup SET ScanDateTime = Getdate () where RegID = 312
Comments
Post a Comment