SQL statements: Creating things

BEGIN TRANTran_money--Start a transactionDECLARE @tran_error int;SET @tran_error = 0; BEGINTRYUPDATETb_moneySETMymoney=Mymoney-  - WHEREName= 'Liu Bei'; SET @tran_error = @tran_error + @ @ERROR; --test the error code to see if Liu Bei's money is reduced and whether Guan Yu's money will increase        --SET @tran_error = 1;        UPDATETb_moneySETMymoney=Mymoney+  - WHEREName= 'Guan Yu'; SET @tran_error = @tran_error + @ @ERROR; ENDTRYBEGINCATCHPRINT 'An exception occurred, error number:' + Convert(varchar, Error_number ())+ ', error message:' +error_message ()SET @tran_error = @tran_error + 1ENDCATCHIF(@tran_error > 0)    BEGIN        --performing an error, rolling back a transaction        ROLLBACK TRAN; PRINT 'transfer failed, cancel transaction!'; ENDELSE    BEGIN        --no exception, COMMIT transaction        COMMIT TRAN; PRINT 'Transfer Success!'; END

SQL statements: Creating things