SET NOCOUNT ON; DECLARE @errorNum int SET @errorNum=0; BEGIN TRANSACTION INSERT_TRAN /**************************************/ SET IDENTITY_INSERT DBO.Cggl_Jwlxqjh ON INSERT INTO Cggl_Jwlxqjh (selfid,。。。。。) SELECT selfid,。。。。。。。 FROM HP_YBFZ.MF5DB.DBO.Cggl_Jwlxqjh SET @errorNum=@@ERROR; IF @errorNum<>0 GOTO LALBE_ROLLBACK; SET IDENTITY_INSERT DBO.Cggl_Jwlxqjh OFF IF @errorNum=0 GOTO LABLE_COMMIT; /**************************************/ LABLE_COMMIT: BEGIN COMMIT TRANSACTION INSERT_TRAN PRINT 'COMMIT TRANSACTION INSERT_TRAN' GOTO LALBE_END; END LALBE_ROLLBACK: BEGIN ROLLBACK TRANSACTION INSERT_TRAN PRINT 'ROLLBACK TRANSACTION INSERT_TRAN' END LALBE_END: BEGIN PRINT 'PROCEDURE EXECUTE END!' END
