Using RollBack in SQL Server Stored Procedure

Question

HiI have multiple sps on same methodmy requirement is that if any exceptiom happens on any one sp automatically undo rollback all changes on particular spcan you please help me

dharmendr · Accepted Answer

Also use SqlTransaction in code behindRefer below articleSqlBulkCopy example with Transaction Commit and Rollback in ASPNet using C and VBNet

Using RollBack in SQL Server Stored Procedure

SqlBulkCopy example with Transaction Commit and Rollback in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us