关于从一个数据库实体A表插入数据到此外一个实体的A表中
关于从一个数据库实体A表插入数据到另外一个实体的A表中
seorder是表头，seorderentry是表体，表头会提示插入重复键，要如何修改这段代码呢？内码系统有个存储过程是计算最大值。要插入到的那个实体的表的初始数据是空，怎么会提示重复呢？
----------销售订单--------------------------------------------------------
insert into SEOrder(FBrNo,FInterID,FBillNo,FCurrencyID,FCustID,FDate,FSaleStyle,FDeptID,FEmpID,FCheckerID,FBillerID,FClosed,FTranType,FMangerID
,FExchangeRate,FStatus ,FPlanCategory,FHeadSelfS0152,FHeadSelfS0153,FHeadSelfS0154,FHeadSelfS0155)
select a.FBrNo,a.FInterID,a.FBillNo,a.FCurrencyID,a.FCustID,a.FDate,a.FSaleStyle,a.FDeptID,a.FEmpID,a.FCheckerID,a.FBillerID,a.FClosed,a.FTranType,a.FMangerID
,a.FExchangeRate,a.FStatus ,a.FPlanCategory,a.FHeadSelfS0152,a.FHeadSelfS0153,a.FHeadSelfS0154,a.FHeadSelfS0155
from xmvk02002.dbo.SEOrder a inner join xmvk02002.dbo.SEOrderEntry b on a.FInterID =b.FInterID where a.FBillNo='VK2015061704'
insert into SEOrderEntry(fbrno,FInterID,FEntryID,FItemID,FQty,FCommitQty,FPrice,FAmount,FTaxRate ,FTaxAmount,FTax ,FDate,FInvoiceQty,FBCommitQty,
FUnitID,FAuxBCommitQty,FAuxPrice,FAuxQty,FSourceEntryID,FStockQty ,FAuxStockQty,FAdviceConsignDate,FAllAmount,FAllStdAmount,
FAuxPriceDiscount,FPriceDiscount,FQtyInvoice,FAuxTaxPrice,FTaxPrice)
select b.fbrno,b.FInterID,b.FEntryID,b.FItemID,b.FQty,b.FCommitQty,b.FPrice,b.FAmount,b.FTaxRate ,b.FTaxAmount,b.FTax ,b.FDate,b.FInvoiceQty,b.FBCommitQty,
b.FUnitID,b.FAuxBCommitQty,b.FAuxPrice,b.FAuxQty,b.FSourceEntryID,b.FStockQty ,b.FAuxStockQty,b.FAdviceConsignDate,b.FAllAmount,b.FAllStdAmount,
b.FAuxPriceDiscount,b.FPriceDiscount,b.FQtyInvoice,b.FAuxTaxPrice,b.FTaxPrice
from xmvk02002.dbo.SEOrder a inner join xmvk02002.dbo.SEOrderEntry b on a.FInterID =b.FInterID where a.FBillNo='VK2015061704'
------解决思路----------------------
因为你再批量插入的时候，要插入的值本身就有重复值，所以才会报错，因为你说 那个insert into的表里是没有数据的
本帖最后由 suzhibo168 于 2015-09-16 10:33:56 编辑
从一个数据库实体A表插入数据到另外一个实体的A表中，两个数据库实体的结构完全一样，表结构也是完全一样，我从数据库实体的A表中选择数据直接插入到另外一个实体的A表中，提示重复键，这个要怎么处理呢？内码？seorder是表头，seorderentry是表体，表头会提示插入重复键，要如何修改这段代码呢？内码系统有个存储过程是计算最大值。要插入到的那个实体的表的初始数据是空，怎么会提示重复呢？
----------销售订单--------------------------------------------------------
insert into SEOrder(FBrNo,FInterID,FBillNo,FCurrencyID,FCustID,FDate,FSaleStyle,FDeptID,FEmpID,FCheckerID,FBillerID,FClosed,FTranType,FMangerID
,FExchangeRate,FStatus ,FPlanCategory,FHeadSelfS0152,FHeadSelfS0153,FHeadSelfS0154,FHeadSelfS0155)
select a.FBrNo,a.FInterID,a.FBillNo,a.FCurrencyID,a.FCustID,a.FDate,a.FSaleStyle,a.FDeptID,a.FEmpID,a.FCheckerID,a.FBillerID,a.FClosed,a.FTranType,a.FMangerID
,a.FExchangeRate,a.FStatus ,a.FPlanCategory,a.FHeadSelfS0152,a.FHeadSelfS0153,a.FHeadSelfS0154,a.FHeadSelfS0155
from xmvk02002.dbo.SEOrder a inner join xmvk02002.dbo.SEOrderEntry b on a.FInterID =b.FInterID where a.FBillNo='VK2015061704'
insert into SEOrderEntry(fbrno,FInterID,FEntryID,FItemID,FQty,FCommitQty,FPrice,FAmount,FTaxRate ,FTaxAmount,FTax ,FDate,FInvoiceQty,FBCommitQty,
FUnitID,FAuxBCommitQty,FAuxPrice,FAuxQty,FSourceEntryID,FStockQty ,FAuxStockQty,FAdviceConsignDate,FAllAmount,FAllStdAmount,
FAuxPriceDiscount,FPriceDiscount,FQtyInvoice,FAuxTaxPrice,FTaxPrice)
select b.fbrno,b.FInterID,b.FEntryID,b.FItemID,b.FQty,b.FCommitQty,b.FPrice,b.FAmount,b.FTaxRate ,b.FTaxAmount,b.FTax ,b.FDate,b.FInvoiceQty,b.FBCommitQty,
b.FUnitID,b.FAuxBCommitQty,b.FAuxPrice,b.FAuxQty,b.FSourceEntryID,b.FStockQty ,b.FAuxStockQty,b.FAdviceConsignDate,b.FAllAmount,b.FAllStdAmount,
b.FAuxPriceDiscount,b.FPriceDiscount,b.FQtyInvoice,b.FAuxTaxPrice,b.FTaxPrice
from xmvk02002.dbo.SEOrder a inner join xmvk02002.dbo.SEOrderEntry b on a.FInterID =b.FInterID where a.FBillNo='VK2015061704'
------解决思路----------------------
因为你再批量插入的时候，要插入的值本身就有重复值，所以才会报错，因为你说 那个insert into的表里是没有数据的