insert into test
select
1 , '红色'
union all select
1 , '36码'
union all select
2 , '蓝色'
union all select
2 , '37码'
union all select
2 , '中国'
select * from test
select bm,STUFF(Parameter,1,1,'') Parameter from (
select bm,(select ','+ Parameter from test
where bm=a.bm for xml path('')) Parameter
from test a ) b