Correctly displays the characters of SQL for XML Path (') that are in transit

The characters in the SQL for XML Path (") are correctly displayed when sending messages at work: because there are links in the contents of the message and several are stitched together, the FOR XML path () is used.
However, the link shown in this way will escape the <,>,& symbol in the path to <> & so that the path shown is not linked in the message.
After searching the internet for a lot of information, finally found a way: ... For Xmlpath ("), TYPE). Value ('. ', ' NVARCHAR (MAX) ')
such as comparison




Transfer from http://blog.sina.com.cn/s/blog_7fbbdb090102vnfo.html

Correctly displays the characters of SQL for XML Path (') that are in transit