[MSSQL]多行拼接

STUFF(
    (SELECT ',' + FirstName + ' ' + LastName 
    FROM tb_Employee
    FOR XML PATH('')
    ),
1, 1, '')  AS Employees

 

posted on 2023-07-06 19:58  z5337  阅读(48)  评论(0)    收藏  举报