XmlCompare

Compares two XML strings

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

Syntax:

SELECT SQLHTTP.net.XmlCompare( @Xml1, @Xml2 )

Arguments:

Name	Type	Description
@Xml1	xml	First XML to be compared.
@Xml2	xml	Second XML to be compared.



Return Type:

bit



Return Values:

0 = The two XML strings ARE NOT the same.
1 = The two XML strings ARE the same.



Sample Usage:


DECLARE @Xml1 xml
DECLARE @Xml2 xml

SET @Xml1 = '<?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>'

SET @Xml2 = '<?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.XmlCompare(@Xml1, @Xml2)

DECLARE @Xml1 xml

DECLARE @Xml2 xml

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

SET @Xml2 = '<?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.XmlCompare(@Xml1, @Xml2)

-----



XmlCompare

Featured API Wrapper Code / SQL Server