搞不明白xml path 就执行一下下面的sql吧

DECLARE @TempTable table(UserID int , UserName nvarchar(50));
insert into @TempTable (UserID,UserName) values (1,'a')
insert into @TempTable (UserID,UserName) values (2,'b')

select UserID,UserName from @TempTable FOR XML PATH

select UserID,UserName from @TempTable FOR XML PATH('test')

select cast(UserID as varchar(max)) + UserName from @TempTable FOR XML PATH('test')

select cast(UserID as varchar(max)) + UserName + ';' from @TempTable FOR XML PATH('')