sqlserver 动态列名拼串_方法3（函数自循环）

CREATE TABLE team(
 [name] [varchar](32) NULL,
 [person] [varchar](32) NULL
 )

 

INSERT INTO team VALUES('A','11')
INSERT INTO team VALUES('A','22')
INSERT INTO team VALUES('F','12')

 

 

  alter  function fun_column2Name(@teamname varchar(32),@cutFlag varchar(1))  
  returns   varchar(4000)  
  as
  begin  
          declare @sql varchar(4000)  
          set @sql = ''  
          select @sql = @sql+@cutFlag+person from team where name = @teamname  
          set @sql = stuff(@sql,1,1,'')  
          return   @sql    
  end
 select name,person = dbo.fun_column2Name(name,'=') from team group by name order by name;