110,537
社区成员
发帖
与我相关
我的任务
分享
drop table tt
create table tt(u_name varchar(50),t_name varchar(50))
insert into tt select 'aaa','1'
insert into tt select 'aaa','2'
insert into tt select 'abc','3'
drop function dbo.f_str
CREATE FUNCTION dbo.f_str(@col1 varchar(10))
RETURNS varchar(100)
AS
BEGIN
DECLARE @re varchar(100)
SET @re=''
SELECT @re=@re+' '+CAST(t_name as varchar)
FROM tt
WHERE u_name=@col1
RETURN(STUFF(@re,1,1,''))
END
select u_name,dbo.f_str(u_name) as t_name
from tt group by u_name