This is right use of SQL transaction Using TRY Catch for
Avoid DeadLock Condition
BEGIN TRANSACTION TransRavi
BEGIN TRY
<Do Your Task Here>
COMMIT TRANSACTION TransRavi
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION TransRavi
END CATCH
BEGIN TRANSACTION TransRavi
BEGIN TRY
<Do Your Task Here>
COMMIT TRANSACTION TransRavi
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION TransRavi
END CATCH
0 comments:
Post a Comment