ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 All rights reserved.How to use RollBack in Stored Procedure in SQL Server<p>This way</p> <pre class="brush: sql">CREATE PROCEDURE MySP AS BEGIN BEGIN TRANSACTION; BEGIN TRY -- Your Queries COMMIT TRANSACTION; END TRY BEGIN CATCH ROLLBACK TRANSACTION; END CATCH; END GO</pre> <p>&nbsp;</p>, 07 Jan 2014 02:41:59 GMT