title: SQL Server : stored procedure transaction
body: <p>Hello I got some stored procedures to create products and other stuff on my site. Now I have to run some of them in a transaction. Is that possible or do I have to make a stored procedure only for the transaction?</p>
  
  <p>Can I say something like</p>
  
  <pre><code>BEGIN TRAN
  "1. stored procedure"
  "2. stored procedure"
  COMMIT
  </code></pre>