title: How to avoid deadlock while updating table with two different updates statements on same table in SQL server
body: <p>I am using update statement in a script task of SSIS which updates a particular row of a table. This process happens in a loop for multiple rows. </p>
  
  <p>Sometimes it happens that another application also fires an update on that same table for a different set of rows. For this application I'm getting deadlock exception on lock. </p>
  
  <p>How can I avoid this situation? I want both updates to work at same time as the row sets being updated are different.</p>
  
  <p>Is the anything to lock only that row which is getting updated?</p>
  
  <p>Regards,<br>
  Solo  </p>