一个SQL列连成字符串的方法

其实很简单，主要是：select @s=@s+列名 from 表 where 条件

create function F_MoteratorName(@sectionid int)
returns nvarchar(2000)
as
begin
declare @name varchar(100)
set @name=''
select @name=@name+(select NickName from Users where EntityId=M.AuthorId)+',' from Moterator M where SectionId=@sectionid
set @name=SUBSTRING(@name,1,len(@name)-1)

return @name
end