ate function fmerg(@company varchar(200))returns varchar(8000)asbegindeclare @str varchar(8000)set @str=''select @str=@str+','+jobname from zhaopin where company=@company set @str=right(@str,len(@str)-1)return(@str)Endgo--调用自定义函数得到结果select distinct company,dbo.fmerg(company) from zhaopin