NodeTable_To_Xml

Constructs an XML from tabular data

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

Syntax:

SELECT SQLHTTP.net.NodeTable_To_Xml()

Arguments:

This procedure requires the SQLHTTP.net.NodeTable to be populated which is normally populated via the Xml_To_NodeTable stored procedure.



Return Type:

xml



Remarks:

This function is intended for users who wish to avoid using XPath syntax. It is not very efficient and only intended for infrequent simple Xml updates.



Sample Usage:


BEGIN TRAN

DECLARE @X xml

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

DELETE SQLHTTP.net.NodeTable

INSERT INTO SQLHTTP.net.NodeTable
SELECT *
FROM SQLHTTP.net.Xml_To_NodeTable(@X)

UPDATE SQLHTTP.net.NodeTable
SET [Value] = 'THIS TEXT IS NEW!!!'
WHERE NodePath = 'DocumentElement/SecondElement/Inline'

SELECT SQLHTTP.net.NodeTable_To_Xml()

DELETE SQLHTTP.net.NodeTable

COMMIT TRAN

BEGIN TRAN

DECLARE @X xml

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

DELETE SQLHTTP.net.NodeTable

INSERT INTO SQLHTTP.net.NodeTable

SELECT *

FROM SQLHTTP.net.Xml_To_NodeTable(@X)

UPDATE SQLHTTP.net.NodeTable

SET [Value] = 'THIS TEXT IS NEW!!!'

WHERE NodePath = 'DocumentElement/SecondElement/Inline'

SELECT SQLHTTP.net.NodeTable_To_Xml()

DELETE SQLHTTP.net.NodeTable

COMMIT TRAN

<?some_pi some_attr="some_value"?>

&#182; Some Text

</FirstElement>

Pre-Text <Inline>THIS TEXT IS NEW!!!</Inline> Post-text.

</SecondElement>

</DocumentElement>



NodeTable_To_Xml

Featured API Wrapper Code / SQL Server