Using ROWLOCK in an INSERT statement (SQL Server)
Posted
by RPS
on Stack Overflow
See other posts from Stack Overflow
or by RPS
Published on 2010-05-18T12:45:39Z
Indexed on
2010/05/18
21:10 UTC
Read the original article
Hit count: 228
sql
|sql-server
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 SQL Server gets busy it will end in Timeout Query returned for SQL Server.
© Stack Overflow or respective owner