SqlServer中查询出多条记录变成一个记录（行变列

DECLARE @names varchar(1000)
SET @names = ''
SELECT @names=@names+ISNULL(name, '')+','
FROM A
WHERE id = 1
select @names

用的是sql的所谓自拼接