Usage of SQL Server T-SQL transactions

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