楼上的办法好象不行IF EXISTS (SELECT * FROM sysobjects WHERE name = N'sumstr') DROP FUNCTION sumstr GO CREATE FUNCTION sumstr(@name nvarchar(50)) RETURNS nvarchar(3000) AS BEGIN declare @sumstr nvarchar(3000) set @sumstr='' select @sumstr=@sumstr+case when @sumstr<>'' then ',' else '' end+[personal like] from aihao where name=@name return(@sumstr) END GO select distinct name as 姓名, dbo.sumstr(name) as 个人爱好 from aihao group by name GO
http://www.csdn.net/expert/topic/789/789814.xml?temp=.2048456
DROP FUNCTION sumstr
GO
CREATE FUNCTION sumstr(@name nvarchar(50))
RETURNS nvarchar(3000)
AS
BEGIN
declare @sumstr nvarchar(3000)
set @sumstr=''
select @sumstr=@sumstr+case when @sumstr<>'' then ',' else '' end+[personal like] from aihao where name=@name
return(@sumstr)
END
GO
select distinct name as 姓名, dbo.sumstr(name) as 个人爱好
from aihao
group by name
GO
准备结帐!