You might have heard about ROLLBACK but you have never used it right ?
If you have used it, its well and good but if Not, then this blog might help you to know, how you can use ROLLBACK in your SP.
Suppose you want to use two insert statement, one by one.
You want to use, @@identity of first insert in another insert statement then this is the best method to go with.
Suppose you are doing first insert operation and some problem occure and any how you are not able to insert data in second table then there might be some database mapping issue.
so here, ROLLBACK can help you to avoid such database problem,
For example, you have used ROLLBACK in your SP, and you are doing first insert operation and if some problem occur and you are not able to insert in second table then ROLLBACk will undo your first insert operation also which will help to avoid database mapping issue.
Below is the syntax of ROLLBACK,
BEGIN TRY BEGIN TRAN BEGIN 'You insert statement COMMIT TRAN END END TRY BEGIN CATCH BEGIN ROLLBACK TRAN PRINT ERROR_MESSAGE() END END CATCH
Hope this post will help you,
if yes please put comment below of this page,
Senior Asp.Net Developer
e-Procurement Technologies Ltd (India)