要连接的Sum的字符串等效项

SELECt
p.ID PersonID,
STUFF(
(SELECT ‘;’ + b.description
FROM personrole a
INNER JOIN role b
ON a.roleid = b.id
WHERe a.personid = p.id
FOR XML PATH (‘’))
, 1, 1, ‘’) AS DescriptionList
FROM person AS p
GROUP BY p.ID

• SQLFiddle演示

输出

╔══════════╦════════════════════════════╗║ PERSonID ║      DEscriptIonLIST       ║╠══════════╬════════════════════════════╣║        1 ║ user ║║        2 ║ user;admininstrator;tester ║╚══════════╩════════════════════════════╝