摘要:原始SQL:SELECT PROVINCE_CODE,CITY_CODE,ZONE_CODEFROM 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
阅读全文
posted @ 2012-10-30 15:25