怎么提取LN-32-173892, 2100, M资料
回答
收藏

怎么提取LN-32-173892, 2100, M资料

陈进雄
2024-03-27 16:11·浏览量:47
陈进雄
发布于 2024-03-27 16:1147浏览

保存新的缺货商品出错!


錯誤代碼:-1

錯誤信息:保存新的缺货商品出错! 错误信息:Violation of PRIMARY KEY constraint 'PK_es_SkuOutOfStock'. Cannot insert duplicate key in object 'dbo.es_SkuOutOfStock'. The duplicate key value is (J, LN-32-173892, 2100, M).

The statement has been terminated.

系統描述:导入缺貨商品

錯誤來源:btnImport_Click


最後執行: INSERT INTO es_SkuOutOfStock(cmp_id,item,col_id,siz_id,modified)  SELECT cmp_id, ltrim(rtrim(item)) as item, ltrim(rtrim(col_id)) as col_id, ltrim(rtrim(siz_id)) as siz_id, modified  FROM #temp_SkuOutOfStock

收藏
全部回答1
最新
发布回答
回答