時間:2024-03-13 13:57作者:下載吧人氣:22
根據name字段,合并code
declare @table1 table ( id int ,code varchar(10) , name varchar(20) );insert into @table1 ( id,code, name ) values ( 1, ‘m1′,’a’ ), ( 2, ‘m2’,null ), ( 3, ‘m3’, ‘c’ ), ( 4, ‘m2′,’d’ ), ( 5, ‘m1′,’c’ );
select * from @table1;
select name, files=stuff((select ‘,’+convert(varchar, code)
from @table1 b
where a.name=b.name
for xml path(”)), 1, 1, ”)
from @table1 a
group by name;
網友評論