sql 将某列转换成一个字符串 for xml path用法

sql 将某列转换成一个字符串 for xml path用法

declare @test table( name varchar(10))
insert into @test values('a')
insert into @test values('b')
insert into @test values('c')
insert into @test values('d')

SELECT * FROM @test

select distinct
(select cast(name AS varchar(2))+','from @test for xml path(''))as name from @test

SELECT * FROM @test FOR XML PATH('name')

posted on 2016-07-25 09:25 影子博客 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/VictorBlog/p/5702356.html