62,046
社区成员
发帖
与我相关
我的任务
分享
ALTER function [dbo].[f_getSplitJointUser](@popedomId int)
returns varchar(4000)
as
begin
declare @result varchar(4000)
set @result=''
select @result=@result+','+userName from uapUser a
inner join sys_userpopedom b on a.userId=b.userId where b.popedomId=@popedomId
select @result=@result+','+userName from sys_Users a
inner join sys_userpopedom b on a.userId=b.userId where b.popedomId=@popedomId
return stuff(@result,1,1,'')
end