-- =============================================
-- Author: tomtom
-- Create date: 2015.2.2
-- Description: 将一列多行拼接为一行,以逗号分隔;递归追加;
-- =============================================
create table ta
(
a varchar(10)
)
go
--#示例数据
insert into ta select '001'
insert into ta select '002'
insert into ta select '003'
select * from ta --列出ta
--#主要过程
declare @newa varchar(100)=''
select @newa=@newa+a +',' from ta
select @newa
/*#执行结果----------
001,002,003,
*/