晨风

-------------------- 业精于勤,荒于嬉;行成于思,毁于随
随笔 - 274, 文章 - 0, 评论 - 36, 阅读 - 111万

导航

SQL拆分字段,一个拆成两个

Posted on   shenyixin  阅读(8858)  评论(1编辑  收藏  举报

原始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

拆分结果:

努力加载评论中...
点击右上角即可分享
微信分享提示