SQL多筆資料合併成一筆, 以逗號隔開

--方法1
SELECT LEFT(FLD1S, LEN(FLD1S)-1) AS FLD1S_MERGE
FROM
(
SELECT
(
SELECT FLD1 + ','
FROM Table1
FOR XML PATH('')
) AS FLD1S
) TT

--方法2
 SELECT STUFF(
(
 SELECT ','+ FLD1
 FROM Table1
 FOR XML PATH('')
)
, 1,1,'') AS FLD1S