Using ROWLOCK in an INSERT statement (MS SQL)
- by RPS
Would it be wise to use ROWLOCK on an insert statement that is copying large amounts of data and inserting it into the same table?
Ex)
INSERT INTO TABLE with (rowlock) (id, name) select newid, name) from TABLE with (nolock) where id = 1
Does anybody have recommendations on how to improve this statement, as I see when MS SQL gets busy it will end in Timeout Query returned for MS SQL.