自增列 插入指定数值

SET NOCOUNT ON;DECLARE @errorNum intSET @errorNum=0;BEGIN TRANSACTION INSERT_TRAN/**************************************/SET IDENTITY_INSERT DBO.Cggl_Jwlxqjh ONINSERT INTO Cggl_Jwlxqjh (selfid,。。。。。)SELECT selfid,。。。。。。。FROM HP_YBFZ.MF5DB.DBO.Cggl_JwlxqjhSET @errorNum=@@ERROR;IF @errorNum<>0GOTO LALBE_ROLLBACK; SET IDENTITY_INSERT DBO.Cggl_Jwlxqjh OFF IF @errorNum=0GOTO LABLE_COMMIT; /**************************************/LABLE_COMMIT:BEGINCOMMIT TRANSACTION INSERT_TRANPRINT 'COMMIT TRANSACTION INSERT_TRAN'GOTO LALBE_END;ENDLALBE_ROLLBACK:BEGINROLLBACK TRANSACTION INSERT_TRANPRINT 'ROLLBACK TRANSACTION INSERT_TRAN'ENDLALBE_END:BEGINPRINT 'PROCEDURE EXECUTE END!'END