What is the purpose of ROWLOCK on Delete and when should I use it?
Posted
by RPS
on Stack Overflow
See other posts from Stack Overflow
or by RPS
Published on 2010-06-09T13:01:57Z
Indexed on
2010/06/09
13:12 UTC
Read the original article
Hit count: 142
Filed under:
sql
Ex)
When should I use this statement:
DELETE TOP (@count) FROM ProductInfo WITH (ROWLOCK) WHERE ProductId = @productId_for_del;
And when should be just doing:
DELETE TOP (@count) FROM ProductInfo WHERE ProductId = @productId_for_del;
© Stack Overflow or respective owner
