sqlserver FOR XML PATH 函数用法以及转义字符正常显示
SELECT *, STUFF(
(SELECT TOP 2 '_' + value FROM dbo.SplitString(COE,'_') FOR XML PATH ('row'), ROOT('root'), TYPE).value('.', 'NVARCHAR(MAX)'),
1, 1, '') FROM dbo.emporg_employee WHERE COE LIKE 'M&C%'
SELECT *, STUFF(
(SELECT TOP 2 '_' + value FROM dbo.SplitString(COE,'_') FOR XML PATH ('row'), ROOT('root'), TYPE).value('.', 'NVARCHAR(MAX)'),
1, 1, '') FROM dbo.emporg_employee WHERE COE LIKE 'M&C%'