首页 > 代码库 > Tran 与 Goto try catch raiserror等浅显应用

Tran 与 Goto try catch raiserror等浅显应用

---- Tran 事务 以及 Goto 的浅显应用IF OBJECT_ID(‘tempdb..#tmptab‘,‘U‘)  IS NOT NULL DROP TABLE #tmptabGOCREATE TABLE #tmptab (id int IDENTITY(1,1),name VARCHAR(10),bankMoney MONEY)GOINSERT INTO #tmptab(name,bankMoney)SELECT ‘Jack‘,100UNIONSELECT ‘Frank‘,200GODECLARE @tran_errorcount INT=0BEGIN TRANSACTION bankTranBEGIN TRY --SELECT 1/0UPDATE #tmptab SET bankMoney=bankMoney+100 WHERE name=‘Jack‘UPDATE #tmptab SET bankMoney=bankMoney-100 WHERE name=‘Frank‘END TRYBEGIN CATCH SET @tran_errorcount+=1DECLARE @error_number INT =ERROR_NUMBER(),		@error_msg VARCHAR(256)=ERROR_MESSAGE()RAISERROR(‘Error Member is: %i and error message: %s‘,-1,-1,@error_number,@error_msg) WITH NOWAITEND CATCHPRINT @tran_errorcountIF @tran_errorcount>0 GOTO error_processELSE GOTO success_processsuccess_process: RAISERROR(‘Transaction finished successfully! Congratulations!‘,-1,-1) WITH NOWAIT COMMIT TRAN GOTO end_process error_process: RAISERROR(‘Warning! Transaction has exception!‘,-1,-1) WITH NOWAIT  ROLLBACK TRANSACTION GOTO end_processend_process: SELECT * FROM #tmptab RETURN

  

Tran 与 Goto try catch raiserror等浅显应用