insert tab values(2,'仍然')
insert tab values(2,'围绕台')
insert tab values(2,'饿热')
insert tab values(5,'统一体眼')
insert tab values(6,'由于')
go
--合并处理函数,用用户定义函数
CREATE FUNCTION dbo.f_str(@col1 varchar(10))
RETURNS varchar(100)
AS
BEGIN
DECLARE @re varchar(100)
SET @re=''
SELECT @re=@re+','+title
FROM tab
WHERE userid=@col1
RETURN(STUFF(@re,1,1,''))
END
GO
select userid,[TITLE个数]=count(userid),[详情]=dbo.f_str(userid) from tab group by userid
go
--删除测试
DROP TABLE tab
DROP FUNCTION f_str
go