sql里怎样将一个表里查询出的多条记录第一个字段组成一个字符串解决方法

declare @str varchar(20)
set @str=''
select @str=@str+','+LTRIM(a01) from A
select RIGHT(@str,LEN(@str)-1) as new

------解决方案--------------------

SQL code

declare @A table (a01 varchar(32))
insert @a select 'aa' union all select  '34' union all select 'b1'

declare @str varchar(20)
set @str=''
select @str=@str+','+LTRIM(a01) from @A
select RIGHT(@str,LEN(@str)-1) as new
/*
new
aa,34,b1
*/