ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. 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>https://www.aspforums.net:443/Threads/152083/How-to-use-RollBack-in-Stored-Procedure-in-SQL-Server/https://www.aspforums.net:443/Threads/152083/How-to-use-RollBack-in-Stored-Procedure-in-SQL-Server/Tue, 07 Jan 2014 02:41:59 GMT