数据库字段中有字符分隔的字符串,转化成多行记录;
Id TrackUserCodes
1 aaa,bbb,ccc
2 eee,fffff,ggggg
将返回 6 条记录
//==============MS SQl 语句如下=====================================================
select Id
,c.value('.','varchar(50)') as UserCode
from H_TaskList a
cross apply(select cast('<row>'+replace(TrackUserCodes,',','</row><row>')+'</row>' as xml) as xmlcode) C1
cross apply xmlcode.nodes('*') t(c)
//================================================================
也可以参考: sql for xml path