SQL语句

先写一个函数

  create function contact(@section varchar(32))
  returns varchar(64)  
  as  
  begin  
    declare @ret varchar(8000)
    set @ret=''  
    select @ret=@ret+','+rtrim(name)  
    from   T_PEOPLE
    where   section=@section  
    return(@ret)  
  end  
  go  

再调用

 select section,name=contact(section)   from   T_PEOPLE   group   by   section