XmlDecode
Decodes a XML-Encoded string.
- Free Function
- SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
SELECT SQLHTTP.net.XmlDecode ( @String )
| Name | Type | Description |
|---|---|---|
| @String | nvarchar(MAX) | Any character string, variable, or expression. |
nvarchar(max)
See the following Wikipedia article on Valid characters in XML
|
1 2 3 |
SELECT SQLHTTP.net.XMLDecode('I_x0020_can_x0020_now_x0020_encode_x0020__x0026__x0020_decode_x0020_an_x0020_XML_x0020_string_x0020_using_x0020_SQL_x0020_Server') |
|
1 2 3 4 |
----------------------------------------------------------- I can now encode & decode an XML string using SQL Server |