JZTXT

[MSSQL]多行拼接

发布时间 2023-07-06 20:05:30作者: z5337
STUFF(
    (SELECT ',' + FirstName + ' ' + LastName 
    FROM tb_Employee
    FOR XML PATH('')
    ),
1, 1, '')  AS Employees