--行合并操作,逗号间隔
SELECT STUFF(
(SELECT ','+Name
FROM Course
FOR XML PATH(''))
, 1, 1, ''
) AS CourseName;
行合并sql语句
最新推荐文章于 2024-06-06 15:47:53 发布
--行合并操作,逗号间隔
SELECT STUFF(
(SELECT ','+Name
FROM Course
FOR XML PATH(''))
, 1, 1, ''
) AS CourseName;