Original in: https://www.lesg.cn/netdaima/2016-55.html
Stored procedures are often required when using MSSQL
Some operations are in front of errors, need to be rolled back;
Here is the code;
BEGIN TRANSACTION--Start a transactionDECLARE @errorSun int=0 --Defining Error CountersDECLARE @ErrorMessage NVARCHAR(4000)="';--DECLARE @Remark NVARCHAR (4000) = ";--remarksBEGINTRYBegin PRINT('here is the body of the code www.lesg.cn/https://www.lesg.cn/netdaima/2016-55.html' ); EendENDTRYBEGINCATCHSELECT@errorSun=-1,@ErrorMessage=error_message ();ENDCATCHIF(@errorSun=-1)BEGINSet @ErrorMessage='(with errors, rolled back)'+@ErrorMessage;Select @errorSun asResualt,@ErrorMessage asMSGROLLBACK TRANSACTION--Transaction rollback StatementsENDELSEBEGINCOMMIT TRANSACTION--Transaction COMMIT Statement END
Original in: https://www.lesg.cn/netdaima/2016-55.html
Usage of SQL Server T-SQL transactions