不能将值 NULL 插入列 'FUserYzjID'，表 'KISTOAIS20210703173513.dbo.KIS_t_User'；列不允许有 Null 值。INSERT 失败。--KIS帐套用户数少于三个的特殊处理，后面会删除这几个用户

IF NOT EXISTS(SELECT 1 FROM KIS_t_User WHERE FUserID = 16395)

BEGIN

INSERT INTO KIS_t_User

(

FUserID,

FName,

FPrimaryGroup,

FEmpID,

FDataVokeType,

FIsNeedOffline,

FRightChanged,

FOfflineRefeshEachTime,

FSafeMode,

FHRUser,

UUID,

FAccessUUID,

FUInValidDate,

FPwCreateDate,

FPwValidDay,

FAuthRight,

FUserTypeID

)

SELECT

16395,

'KIS!@#$TMP'+'16395',

NEWID(),

GETDATE(),

END

IF NOT EXISTS(SELECT 1 FROM KIS_t_User WHERE FUserID = 16396)

BEGIN

INSERT INTO KIS_t_User

(

FUserID,

FName,

FPrimaryGroup,

FEmpID,

FDataVokeType,

FIsNeedOffline,

FRightChanged,

FOfflineRefeshEachTime,

FSafeMode,

FHRUser,

UUID,

FAccessUUID,

FUInValidDate,

FPwCreateDate,

FPwValidDay,

FAuthRight,

FUserTypeID

)

SELECT

16396,

'KIS!@#$TMP'+'16396',

NEWID(),

GETDATE(),

END

IF NOT EXISTS(SELECT 1 FROM KIS_t_User WHERE FUserID = 16397)

BEGIN

INSERT INTO KIS_t_User

(

FUserID,

FName,

FPrimaryGroup,

FEmpID,

FDataVokeType,

FIsNeedOffline,

FRightChanged,

FOfflineRefeshEachTime,

FSafeMode,

FHRUser,

UUID,

FAccessUUID,

FUInValidDate,

FPwCreateDate,

FPwValidDay,

FAuthRight,

FUserTypeID

)

SELECT

16397,

'KIS!@#$TMP'+'16397',

NEWID(),

GETDATE(),

END

产品问题KIS专业版 15.0数据迁移KIS旗舰版提示失败。

产品问题 KIS专业版 15.0数据迁移KIS旗舰版提示失败。

恭喜您！

产品问题
KIS专业版 15.0数据迁移KIS旗舰版提示失败。