Rollback an entire stored procedure
<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>