表如下:
id desc
-------------------
1 a
1 b
2 k
2 l
2 m
sql语句实现字符串的合并?即得到如下结果:
id desc
------------------
1 ab
2 klm
==============================================================
先建一个函数:
create function getstr(@id int)
returns varchar(100)
as
begin
declare @c varchar(100)
set @c=''
select @c=@c+rtrim([desc]) from t1 where id=@id
return @c
end
语句:
select id,dbo.getstr(id) as [desc] from t1 group by id