sql - Update Query with Nolock hint -


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