title: How does SQL Server treat statements inside stored procedures with respect to transactions?
body: <p>Say I have a stored procedure consisting of several separate SELECT, INSERT, UPDATE and DELETE statements. There is no explicit BEGIN TRANS / COMMIT TRANS / ROLLBACK TRANS logic. </p>
  
  <p>How will SQL Server handle this stored procedure transaction-wise? Will there be an implicit connection for each statement? Or will there be one transaction for the stored procedure?</p>
  
  <p>Also, how could I have found this out on my own using T-SQL and / or SQL Server Management Studio?</p>
  
  <p>Thanks!</p>