原始SQL:
SELECT PROVINCE_CODE, CITY_CODE, ZONE_CODE FROM CIV_P_CUST
原始结果:
拆分SQL:
SELECT substring(PROVINCE_CODE,1,patindex('%〓%',PROVINCE_CODE)-1) as PID, substring(PROVINCE_CODE,patindex('%〓%',PROVINCE_CODE)+1,len(PROVINCE_CODE)) as PNAME, substring(CITY_CODE,1,patindex('%〓%',CITY_CODE)-1) as CID, substring(CITY_CODE,patindex('%〓%',CITY_CODE)+1,len(CITY_CODE)) as CNAME, substring(ZONE_CODE,1,patindex('%〓%',ZONE_CODE)-1) as ZID, substring(ZONE_CODE,patindex('%〓%',ZONE_CODE)+1,len(ZONE_CODE)) as ZNAME FROM CIV_P_CUST
拆分结果:
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步