多列转一列，并加分隔符

create table table_1
(
id int,
[name] varchar(8)
)

go

insert into table_1
select 1,'tom' union all
select 2,'john' union all
select 3,'jerry'
go

 

输出结果

1,2,3

 

declare @s varchar(12),@result varchar(max)
select @s = ',',@result = ''  --@s表示分隔符,
select @result = @result + @s + Convert(varchar(10),id) from table_1
select @result =stuff(@result,1,len(@s),'')
select @result