Discussion on SQL2000 transaction rollback problem _mssql

Copy Code code as follows:

CREATE PROCEDURE Test_tran
As
The set XACT_ABORT on-----with the @ @error, for serious errors, the system does not perform subsequent judgments of the @ @error and terminates execution directly. So setting set XACT_ABORT on is necessary
BEGIN TRANSACTION Remoteupdate
Insert Psn_degree values (' Test ')
Select 1/0
IF @ @error!=0 BEGIN
ROLLBACK TRANSACTION Remoteupdate
RAISERROR (' Wrong! Slow or disconnected network speed! ', with SetError
Return---There will be continued down execution
End
ELSE begin
COMMIT TRANSACTION Remoteupdate
End

can also be changed to:

Copy Code code as follows:

IF @ @error!=0 BEGIN
ROLLBACK TRANSACTION Remoteupdate
RAISERROR (' Wrong! Slow or disconnected network speed! ', with SetError
Return---There will be continued down execution
End
COMMIT TRANSACTION Remoteupdate