sqlserver列名用逗号分隔

 

SELECT * FROM dbo.ST_City

DECLARE @sql NVARCHAR(2000)
SELECT TOP 10 @sql=ISNULL(@sql+',','')+cName FROM ST_City
GROUP BY cName
SELECT @sql