sql try catch

BEGIN TRY  
            BEGIN TRAN
             --操作语句
            COMMIT TRAN;  
END TRY  
BEGIN CATCH     
      SET @ErrorMessage = ERROR_MESSAGE()
ROLLBACK TRAN; END CATCH
posted @ 2019-10-08 18:32  _jwj  阅读(147)  评论(0编辑  收藏  举报