金蝶EAS Cloud 组织编码下划线替换样例.docx

④内部公开请勿外传--第一步：以下放在查询分析器中，选中>>执行sqlSELECT*INTOT_ORG_BASEUNIT_BAK0806fromT_ORG_BASEUNITwherecharindex(_,FNUMBER)>0;updateT_ORG_BASEUNITorgsetFNUMBER=replace(FNUMBER,_,-),FLONGNUMBER=replace(FLONGNUMBER,_,-)WHEREexists(SELECT1FROMT_ORG_BASEUNIT_BAK0806bakwherebak.fid=org.fid);SELECT*INTOT_ORG_Admin_BAK0806fromT_ORG_Adminwherecharindex(_,FNUMBER)>0;updateT_ORG_Adminorgs...