蔡培培要求改批号

最新推荐文章于 2023-12-05 23:48:13 发布

NO66781

最新推荐文章于 2023-12-05 23:48:13 发布

阅读量602

点赞数

分类专栏：时空智友

本文链接：https://blog.csdn.net/NO66781/article/details/103685635

版权

时空智友专栏收录该内容

61 篇文章 65 订阅

订阅专栏

SELECT * FROM GOODSDOC WHERE GoodsCode ='QXEL0207'

SELECT * FROM PURINDT WHERE EntId ='E2SVHJM7RVQ' AND GoodsId ='G2VKOVJGMEY'



SELECT * FROM BATCHCODE WHERE EntId ='E2SVHJM7RVQ' AND GoodsId ='G2VKOVJGMEY'


SELECT * FROM SALENOTESDT WHERE EntId ='E2SVHJM7RVQ' AND GoodsId ='G2VKOVJGMEY' AND AngleId='L2WVY0YNE8Y'
 

--20181028  20191028

--UPDATE BATCHCODE SET BatchCode='20191028',ProduceDate='2019-10-28' WHERE EntId ='E2SVHJM7RVQ' AND GoodsId ='G2VKOVJGMEY' AND AngleId='L2WVY0YNE8Y'
--UPDATE SALENOTESDT SET BatchCode='20191028',ProduceDate='2019-10-28' WHERE EntId ='E2SVHJM7RVQ' AND GoodsId ='G2VKOVJGMEY' AND AngleId='L2WVY0YNE8Y'
--UPDATE V_ERP_XSCK_HIS SET PH ='20191028',RQ_SC='2019-10-28'  WHERE spid='G2VKOVJGMEY' AND PH ='20181028'
--UPDATE Skzy_Main.dbo.V_ERP_XSCK_HIS SET PH ='20191028',RQ_SC='2019-10-28'  WHERE spid='G2VKOVJGMEY' AND PH ='20181028'
--UPDATE ZJK.GZWMSZJK.dbo.V_ERP_XSCK SET PH ='20191028',RQ_SC='2019-10-28'  WHERE spid='G2VKOVJGMEY' AND PH ='20181028'

关注博主即可阅读全文