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