title: Lock on table while inserting data in SQL Server database
body: <p>I have question on lock on table in SQL Server while inserting data using multiple processes at a single time into same table.</p>
  
  <p>Here are my questions on this,</p>
  
  <ol>
  <li>Is it default behavior of SQL server to lock table while doing insert? </li>
  <li>if yes to Q1, then how we can implicitly mention while inserting data. </li>
  <li>If I have 4 tables and one table has foreign keys from rest of the 3 tables, on this scenario do I need to use the table lock explicitly or without that I can insert records into those tables?</li>
  </ol>
  
  <p>Please help me to understand the same.</p>