title: Table lock in Stored procedure
body: <p>I am using Stored Procedure which is returning 5-6 tables and this procedure may be in use simultaneous by many users (5-10 users) at same time.</p>
  
  <p>Procedure has only "Select" statements.</p>
  
  <p>So I just wanted to confirm is there any lock apply for the tables of Stored Procedure whenever the Procedure will call or there will be no lock.</p>
  
  <p>I am using MS SQL Server 2012 and Visual Studio 2013.</p>