今天由于工作需要，需要把數據把列根據指定的內容拆分數據

其中一條數據實例

 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′