创建一个合并的函数:
create function fmerge(@id VARCHAR(20))
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+b from table1 where a=@id
return(@str)
End
go--调用自定义函数得到结果
select distinct a,dbo.fmerge(a) from table1
create function fmerge(@id VARCHAR(20))
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+b from table1 where a=@id
return(@str)
End
go--调用自定义函数得到结果
select distinct a,dbo.fmerge(a) from table1
CREATE FUNCTION dbo.f
(
@a varchar(10)
)
returns varchar(3000)
As
Begin
declare @answer varchar(3000)
select @answer = ''
select @answer=@answer+a from table1 where a=@a
return @answer
End用的时候
select dbo.f(a) from table1