将一个表中A中ID重复的字段name全部合并的存储过程;
表A
ID name ID name
1 A 1 ABC
1 B 合并后 2 H
2 H 3 CD
3 CD
1 C
------解决方案--------------------
- SQL code
create table tb(ID int, name varchar(10))insert into tb values(1, 'A')insert into tb values(1, 'B')insert into tb values(2, 'H')insert into tb values(3, 'CD') insert into tb values(1, 'C') go--创建一个合并的函数create function f_hb(@id int)returns varchar(8000)asbegin declare @str varchar(8000) set @str = '' select @str = @str + cast(name as varchar) from tb where id = @id set @str = right(@str , len(@str)) return(@str)Endgo--调用自定义函数得到结果：select distinct id ,dbo.f_hb(id) as name from tbdrop table tbdrop function dbo.f_hb/*id name ----------- --------1 ABC2 H3 CD（所影响的行数为 3 行）*/