Sqlserver列的内容连接为字符串用逗号分隔

 create table connectColumn
(
 ID int,
 ColValue varchar(50)
)

 

insert into connectColumn values  (1,'A');

insert into connectColumn values  (2,'B');
insert into connectColumn values  (3,'C');

 

declare @rowValue varchar(2000);
set @rowValue = '';
select @rowValue= @rowValue + ',' + colValue from connectColumn;

if(len(@rowValue) > 0)
 set @rowValue = right(@rowValue, len(@rowValue) - 1);
print @rowValue;

the result: A,B,C