sql server 使用for xml path 将1列多行转换为字符串连接起来

select * from tb
--查询
select
  id,
  name=stuff((select ','+name from tb where id=t.id for xml path('')),1,1,'')
from
  tb t
group by
  id

方法二：

CREATE FUNCTION GET_STRING(@ID INT)
RETURNS VARCHAR(50)
AS
  BEGIN
       DECLARE @NAME VARCHAR(500)
       SELECT @NAME=ISNULL(@NAME+',','')+NAME FROM TB WHERE ID=@ID
       RETURN @NAME
  END


SELECT ID ,DBO.GET_STRING(ID)NAME FROM TB GROUP BY ID