文章分类 - PS10巴食川珍
摘要：select * from CRMSKD WHERE CRMSKD_DWBH='1638' UPDATE CRMSKD SET CRMSKD_DWMC='老谢' WHERE CRMSKD_DWBH='1638' select * from CRMSKD WHERE CRMSKD_DWBH='1638
阅读全文
摘要：select * from XSDDMX,XSTDMX where XSDDMX_DDLS=XSTDMX_DDLS and XSDDMX_DDFL=XSTDMX_DDFL and XSTDMX_DDBH='@'
阅读全文
摘要：更新单据日期和业务日期不等的情况 UPDATE XSTD SET XSTD_YWRQ=XSTD_DJRQ WHERE XSTD_DJRQ<>XSTD_YWRQ UPDATE KCCKD1 SET KCCKD1_DJRQ=KCCKD1_KCYWRQ WHERE KCCKD1_DJRQ<>KCCKD1_
阅读全文
摘要：--1、检查年度分表是否存在SELECT * FROM ZWKMJE2024 --2、年度分表不存在，则新建，即可解决 SELECT * INTO ZWKMJE2024 FROM ZWKMJE
阅读全文
摘要：select * from ZWDWJHZD 检查销售订单地址是否有错误 select XSDD_DHDD,XSDD_DDBH,XSDD_C10,ZWDWJHZD_JHDD from XSDD,ZWDWJHZD WHERE XSDD_DZBH_ID IS NOT NULL AND LEN(XSDD_
阅读全文
