物料盘点作业审核时报错提示dbo.T_DIN_StockCountDate中插入重复键

问题描述：

解决方案：

cloud中执行脚本

----盘点时间表修改主键

 IF NOT EXISTS (SELECT 1 FROM SYSCONSTRAINTS CONST INNER JOIN SYSOBJECTS CONST_OBJ ON CONST.CONSTID = CONST_OBJ.ID WHERE CONST_OBJ.NAME = 'PK_StockCountDate_N') BEGIN DELETE FROM T_DIN_StockCountDate; ALTER TABLE T_DIN_StockCountDate DROP CONSTRAINT PK_StockCountDate; ALTER