sql server - Rollback to a previous save point in T-SQL -


read documentation seems cannot it.

i have transactions this:

begin transaction    statement 1    statement 2    statement 3 commit 

what want this:

begin transaction    if statement 1 fails rollback beginning else create savepoint1    if statement 2 fails rollback beginning else create savepoint2    if statement 3 fails rollback beginning else create savepoint3    if executed commit 

any hints syntax? statements inserts , updates same table , current setup gave me deadlock.

regards,


Comments

Popular posts from this blog

html - How to set bootstrap input responsive width? -

javascript - Highchart x and y axes data from json -

javascript - Get js console.log as python variable in QWebView pyqt -