Select t1.PA_PURCHASE,t1.PURCHASE_D_CODE,t1.PART_NO,t1.PART_NAME,t1.PURCHASE_UINT,t1.ORDER_NUM,t1.CAR_TYPE
,dbo.F_GETBASEVALUE('PART_TYPE', t1.PART_TYPE,1) PART_TYPE,t1.PURCHASE_DEPT
,convert(varchar(10),t1.PART_ARR_DATE,120) PART_ARR_DATE,t1.USE_DESC ,t1.REMARK
,dbo.F_NameLongToShort(dbo.GetEmpName(t1.APPLY_PERSON)) APPLY_PERSON,t1.PLAN_APPLY_CODE,t1.PURCHASE_ASS
,t1.IN_STORAGE_NUM ,'' as PART_ID From T_ST_DB_PA_PURCHASE t1
怎么样利用字符串分割截取获取以上sql语句中的字段名,如果用,号分割dbo.F_GETBASEVALUE('PART_TYPE', t1.PART_TYPE,1) PART_TYP怎么处理?
,dbo.F_GETBASEVALUE('PART_TYPE', t1.PART_TYPE,1) PART_TYPE,t1.PURCHASE_DEPT
,convert(varchar(10),t1.PART_ARR_DATE,120) PART_ARR_DATE,t1.USE_DESC ,t1.REMARK
,dbo.F_NameLongToShort(dbo.GetEmpName(t1.APPLY_PERSON)) APPLY_PERSON,t1.PLAN_APPLY_CODE,t1.PURCHASE_ASS
,t1.IN_STORAGE_NUM ,'' as PART_ID From T_ST_DB_PA_PURCHASE t1
怎么样利用字符串分割截取获取以上sql语句中的字段名,如果用,号分割dbo.F_GETBASEVALUE('PART_TYPE', t1.PART_TYPE,1) PART_TYP怎么处理?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货