![](https://img-blog.csdnimg.cn/img_convert/24ece7e705218647d1aa78fc92fec9b7.png)
SELECT STUFF((SELECT ','+KR_CHILDSTR FROM KindRelation WHERE KR_OBJECTTYPE=8 AND KR_OBJECTID=3 AND KR_OBJECTID2=81 FOR XML PATH(''),TYPE).value('.','NVARCHAR(MAX)'),1,1,'')
![](https://img-blog.csdnimg.cn/img_convert/2bfa4fbc38f7a5efc55e2b4945a1c82d.png)
上面语句既能满足行转列,又能去除XML格式,比如大于号、小于号,归功于后面的这部分代码
,TYPE).value('.','NVARCHAR(MAX)')