title: Rollback an entire stored procedure
body: <p>I have a stored procedure with multiple update statements.I dont want to use try catch.How can I rollback the stored procedure and get back the original table?</p>
  
  <p>can something like this work -</p>
  
  <p>begin transaction t1
  spName
  rollback transaction t1</p>