title: What is the purpose of ROWLOCK on Delete and when should I use it?
body: <p>Ex)</p>
  
  <p>When should I use this statement:</p>
  
  <pre><code>DELETE TOP (@count)
  FROM ProductInfo WITH (ROWLOCK)
  WHERE ProductId = @productId_for_del;
  </code></pre>
  
  <p>And when should be just doing:</p>
  
  <pre><code>DELETE TOP (@count)
  FROM ProductInfo
  WHERE ProductId = @productId_for_del;
  </code></pre>