金蝶kis旗舰版账套管理登录提示下标越界?
服务热线：400-665-0027
新购有特价、金蝶老客户升级金蝶云产品可以享受5折优惠，送手机、送话费，好礼不断！
use AcctCtl_KEE
--备份
select * into t_ad_kdAccount_gl_bak from t_ad_kdAccount_gl
--查看这几个数据有没有重复的值，这三个字段需要均为1，非1的，修改到不重复为止
select COUNT(FAcctName),FAcctName from t_ad_kdAccount_gl group by FAcctName
select COUNT(FAcctNumber),FAcctNumber from t_ad_kdAccount_gl group by FAcctNumber
select COUNT(FAcctID),FAcctID from t_ad_kdAccount_gl group by FAcctID
--把缺少信息单元格填充
select FVersion，* from t_ad_kdAccount_gl where FVersion=null
select FNodeID，* from t_ad_kdAccount_gl where FNodeID=0
update t_ad_kdAccount_gl set FNodeID=1 where FNodeID=0
update t_ad_kdAccount_gl set FVersion=‘5.0.01.23 where FVersion=null
--5.0.01.23替换为实际的版本号