Question

当IDENTITY_INSERT 设置为 OFF 时，不能为表 'Level5Products' 中的标识列插入显式值

insert into GTI_R2.dbo.Level5Products(PID, PCode5, RName, PName, PYName, WBName, UnitType, Alias, Model, FromPlace, ShortFromPlace, PuRate, ProductSubTypeID, BaseUnit,                       UnitRate, ShelfLifeYear, ShelfLifeMonth, GMP, [External], PTypeID, OTC, AddDate, Imported, Maintenance, QualityStandard, Trail, TrailEndDate,                       ExpiryControl, Medicare, Status, ProductRetailTypeID, RetailUnit, RetailUnitRate, Applications, Storage, Utility, ExamineItems, MinUnitRate, Outlet,                       price_in, FirstInDate, xkz, StockLevel, ReturnProfit, Visible, lastRequestQuan, Bonus, ProductGroupID, bAllowPur, NullValue, Medrebate, integral,                       YbType, YbType2, YbType3, YbCode, YbName, YbUnitType, Ybzfbl, YbCis, DrugFlag, Nointer, INTEGERAL, nospec, bZP)(SELECT     PID, PCode5, RName, PName, PYName, WBName, UnitType, Alias, Model, FromPlace, ShortFromPlace, PuRate, ProductSubTypeID, BaseUnit,                       UnitRate, ShelfLifeYear, ShelfLifeMonth, GMP, [External], PTypeID, OTC, AddDate, Imported, Maintenance, QualityStandard, Trail, TrailEndDate,                       ExpiryControl, Medicare, Status, ProductRetailTypeID, RetailUnit, RetailUnitRate, Applications, Storage, Utility, ExamineItems, MinUnitRate, Outlet,                       price_in, FirstInDate, xkz, StockLevel, ReturnProfit, Visible, lastRequestQuan, Bonus, ProductGroupID, bAllowPur, NullValue, Medrebate, integral,                       YbType, YbType2, YbType3, YbCode, YbName, YbUnitType, Ybzfbl, YbCis, DrugFlag, Nointer, INTEGERAL, nospec, bZP from GTI_R1.dbo.Level5Products) 报错：当 IDENTITY_INSERT 设置为 OFF 时，不能为表 'Level5Products' 中的标识列插入显式值

Answer 1

你写这是什么啊吗？这样没有一个会帮你的！没有人有这么耐心的！ok