SQL 合并函数
方法一:
--创建一个合并的函数
create function f_hb(@id int)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str = ''
select @str = @str + ',' + cast(DepartID as varchar) from UserDept
where UserID = @id
set @str = right(@str , len(@str) - 1)
return(@str)
End
go
--调用自定义函数得到结果:
select distinct UserID ,dbo.f_hb(UserID) as value from UserDept
drop function dbo.f_hb