用函数 暂定表名为test1,字段1为name,字段2为score 函数如下: CREATE function f_hb(@xm varchar(50)) returns varchar(8000) as begin declare @str varchar(8000) set @str = '' select @str = @str + ' ' + cast(score as varchar) from test1 where name = @xm set @str = right(@str , len(@str) - 1) return(@str) End调用如下: select distinct name ,dbo.f_hb(name) as name1 from test1PS:极度BS蛋帖!!!
暂定表名为test1,字段1为name,字段2为score
函数如下:
CREATE function f_hb(@xm varchar(50))
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str = ''
select @str = @str + ' ' + cast(score as varchar) from test1 where name = @xm
set @str = right(@str , len(@str) - 1)
return(@str)
End调用如下:
select distinct name ,dbo.f_hb(name) as name1 from test1PS:极度BS蛋帖!!!