for xml path('') 特殊符号转码问题

DROP TABLE IF EXISTS #Temp_Testxml

CREATE TABLE #Temp_Testxml(
	Title varchar(200)
)

INSERT INTO #Temp_Testxml
values('Benefits Administration Software'),
('<Benefits Program Design>'),
('Budget Administration'),
('Compensation & Benefit'),
('Compensation Management Software'),
('Compensation Program Design'),
('Health & Welfare Benefits'),
('HR Regulatory Compliance'),
('Incentive Programs'),
('Retirement Benefits'),
('test skill1')

SELECT Title 
FROM #Temp_Testxml
for xml path('')

以上代码查询结果：

|Benefits Administration Software|<Benefits Program Design>|Budget Administration|Compensation & Benefit|Compensation Management Software|Compensation Program Design|Health & Welfare Benefits|HR Regulatory Compliance|Incentive Programs|Retirement Benefits|test skill1

我们发现 原本