Forum Replies Created
Viewing post 1 (of 1 total)
-
RE: How to lock rows for update?
UPDATE tblGood with (rowlock) SET userID = @userid, DateUpd = @DateUpd WHERE ID in ( SELECT top 5 ID from tblGood where userID is null
Viewing post 1 (of 1 total)
Viewing post 1 (of 1 total)
UPDATE tblGood with (rowlock) SET userID = @userid, DateUpd = @DateUpd WHERE ID in ( SELECT top 5 ID from tblGood where userID is null
Viewing post 1 (of 1 total)