title: SQL Server lock due to select while inserting
body: <p>I want to fetch some rows from a table while insertion is being done in that same table. While doing this operation, the table is being locked. </p>
  
  <p>How can I fix this?</p>
  
  <p>kindly help me out.</p>
  
  <p>Thanks in advance</p>