SQL将多行结果合并成一行

CREATE TABLE #TB(
	ID INT,
	CAS VARCHAR(255)
)
INSERT INTO #TB VALUES(1,'语文')
INSERT INTO #TB VALUES(2,'数学')
INSERT INTO #TB VALUES(3,'英语')

SELECT STUFF((
	SELECT ',' + CAS FROM #TB FOR XML PATH('')
),1,1,'') AS 科目

DROP TABLE #TB