今天由于工作需要，需要把數(shù)據(jù)把列根據(jù)指定的內(nèi)容拆分?jǐn)?shù)據(jù)

其中一條數(shù)據(jù)實(shí)例

 select id , XXXX FROM BIZ_PAPER where  id =’4af210ec675927fa016772bf7dd025b0′

拆分方法：

select t3.id ,t3.XXXX as XXXX from (
select A.id , B.XXXX from (
SELECT id, XXXX = CONVERT(xml,'<root><v>’ + REPLACE(XXXX , ‘,’, ‘</v><v>’) + ‘</v></root>’) FROM BIZ_PAPER) A
outer apply(
SELECT XXXX = N.v.value(‘.’, ‘varchar(100)’) FROM A.XXXX .nodes(‘/root/v’) N(v)) B) t3 where t3.id =’4af210ec675927fa016772bf7dd025b0′