declare @a varchar(1000)
select @a=isnull(@a+'、','')+b_name from [Table] order by id

select @a

DECLARE @SQL NVARCHAR(1000)
SET @SQL=''
SELECT @SQL=@SQL+b_name+',' from [TABLE1]
EXEC('SELECT 组合='''+@sql+'''')

declare @a nvarchar(8000)
select @a=isnull(@a+',','')+b_name from Table1表格 order by id
select @a

SQL codedeclare @a nvarchar(4000)
select @a=isnull(@a+'、','')+b_name from Table1表格 order by id
select @a