语句已终止。
违反了 UNIQUE KEY 约束 'uk_Account'。不能在对象 'dbo.t_Account' 中插入重复键。Insert into t_Account(
FAccountID,
FNumber,
FName,
FLevel,
FDetail,
FParentID,
FRootID,
FGroupID,
FDC,
FHelperCode,
FCurrencyID,
FAdjustRate,
FEarnAccountID,
FQuantities,
FUnitGroupID,
FMeasureUnitID,
FIsCash,
FIsBank,
FJournal,
FContact,
FIsCashFlow,
FDetailID,
FAcnt,
FLoan,
FDpst,
FStatedDpst,
FInterest,
FIsAcnt,
FIsBudget,
FAcntID,
FBrNo,
FAcctint,
FintRate,
FLastintDate,
FAcntType,
FTradeNum,
FControl,
FViewMsg,
FMessage,
FDelete,
FIsBusi,
FFullName,
--FModifyTime,
FSystemType,
FControlSystem,
UUID
--FCFItemID, K/3中字段, KIS中没有
--FSubCFItemID, K/3中字段, KIS中没有
--FClassTypeID K/3中字段, KIS中没有
)
Select
FAccountID,
FNumber,
FName,
FLevel,
FDetail,
FParentID,
FRootID,
FGroupID,
FDC,
FHelperCode,
FCurrencyID,
FAdjustRate,
FEarnAccountID,
FQuantities,
FUnitGroupID,
FMeasureUnitID,
FIsCash,
FIsBank,
FJournal,
FContact,
FIsCashFlow,
FDetailID,
FAcnt,
FLoan,
FDpst,
FStatedDpst,
FInterest,
FIsAcnt,
FIsBudget,
FAcntID,
FBrNo,
FAcctint,
FintRate,
FLastintDate,
FAcntType,
FTradeNum,
FControl,
FViewMsg,
FMessage,
FDelete,
FIsBusi,
FFullName,
--FModifyTime,
FSystemType,
FControlSystem,
UUID
from KIS_t_Account where Left(FGroupID,1) not in (6, 7) --对于共同类和表外科目需要另外处理
共同类 表外科目也已经在数据库里删除了也还是这个提示无法升级