做个自定义的函数:
create function mergesp(@name varchar(10))
retrurns varchar(1000)
as
begin
declare @s varchar(1000)
set @s=''
select @s=@s+sports from tablename where name=@name
return(@s)
end
go
select name,sports=select dbo.mergesp(name) from tablename
create function mergesp(@name varchar(10))
retrurns varchar(1000)
as
begin
declare @s varchar(1000)
set @s=''
select @s=@s+sports from tablename where name=@name
return(@s)
end
go
select name,sports=select dbo.mergesp(name) from tablename
(
@Name NVARCHAR(10)
)
RETURNS NVARCHAR(100)
AS
BEGIN
DECLARE @Result NVARCHAR(100)
SET @Result = '' SELECT @Result = @Result + 爱好
FROM 表
WHERE 姓名 = @Name RETURN @Result
ENDSELECT 姓名, dbo.fnGetFavorite(姓名) AS 爱好
FROM 表
GROUP BY 姓名