修改客户名称

select * from CRMSKD  WHERE CRMSKD_DWBH='1638'
 UPDATE CRMSKD SET CRMSKD_DWMC='老谢'  WHERE CRMSKD_DWBH='1638'


select * from CRMSKD  WHERE CRMSKD_DWBH='1638'
UPDATE CRMSKD SET CRMSKD_DWMC='老谢'  WHERE CRMSKD_DWBH='1638'

select * from XSDD WHERE XSDD_C9='1638'
UPDATE XSDD SET XSDD_SPKHMC='老谢',XSDD_FKKHMC='老谢',
XSDD_SHDKHMC='老谢',XSDD_SODKHMC='老谢',
XSDD_C10='老谢' WHERE XSDD_C9='1638'

select * from XSTD WHERE XSTD_C9='1638'
UPDATE XSTD SET XSTD_SPKHMC='老谢',XSTD_FKKHMC='老谢',
XSTD_SHDKHMC='老谢',XSTD_SODKHMC='老谢',
XSTD_C10='老谢' WHERE XSTD_C9='1638'

select * from KCCKD1 WHERE KCCKD1_C9='1638'
update KCCKD1 set KCCKD1_DWMC='老谢',KCCKD1_C10='老谢' WHERE KCCKD1_C9='1638'

SELECT  * FROM 客户编码器 where ERP客户编码='1638'
UPDATE 客户编码器 SET 客户名称='老谢' where ERP客户编码='1638'

SELECT  * FROM ZWWLDW where ZWWLDW_DWBH='1638'
UPDATE ZWWLDW SET ZWWLDW_DWMC='老谢' where ZWWLDW_DWBH='1638'

 

posted @ 2024-08-03 10:51  CelonY  阅读(8)  评论(0)    收藏  举报