摘要：
原始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 shenyixin 阅读(8842) 评论(1) 推荐(0) 编辑