IsXmlValid

Checks the validity of an XML

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.IsXmlValid( @XmlString )

Arguments:

Name	Type	Description
@XmlString	nvarchar(MAX)	String to validate.



Return Type:

bit



Return Values:

0 = XML is NOT Valid
1 = XML IS Valid



Sample Usage:


DECLARE @XmlString nvarchar(MAX)

SET @XmlString = '<?xml version="1.0" encoding="UTF-8"?>
 <DocumentElement param="value">
     <FirstElement>
         &#xb6; Some Text
     </FirstElement>
     <?some_pi some_attr="some_value"?>
     <SecondElement param2="something">
         Pre-Text <Inline>Inlined text</Inline> Post-text.
     </SecondElement>
</DocumentElement>'

SELECT SQLHTTP.net.IsXmlValid(@XmlString)

DECLARE @XmlString nvarchar(MAX)

SET @XmlString = '<?xml version="1.0" encoding="UTF-8"?>

¶ Some Text

</FirstElement>

<?some_pi some_attr="some_value"?>

Pre-Text <Inline>Inlined text</Inline> Post-text.

</SecondElement>

</DocumentElement>'

SELECT SQLHTTP.net.IsXmlValid(@XmlString)

-----



IsXmlValid

Featured API Wrapper Code / SQL Server