title: Isolation Level for stored procedure SQL Server?
body: <p>I want to add Isolation level in my procedure and for that I wanted to confirm that which one is the correct format from below:</p>
  
  <p>Attempt #1 - setting isolation level before calling the stored procedure:</p>
  
  <pre><code>SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
  
  EXEC [sp_GetProductDetails] 'ABCD','2017-02-20T11:51:37.3178768'
  </code></pre>
  
  <p>Attempt #2 - setting isolation level inside the stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE MySP AS
  BEGIN
     SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
     BEGIN TRAN 
         SELECT * FROM MyTable
         SELECT * FROM MyTable2
         SELECT * FROM MyTable3
  
         COMMIT TRAN  
  END
  </code></pre>
  
  <p>Please suggest.</p>