Unable to Parse XML using Sp_XML_Prepare document when namespaces are present

Question

Hi,

I have an XML with namespaces. I am unable to parse it using sp_xml_preparedocument. I am able to parse if name spaces are removed from XML. Also I tried passing name spaces to Sp as parameter. But it is not returning any result.
Below is the Namespaces node.

'<SyncPurchaseOrder 
xmlns="http://schema.inf.com/infOAGIS/2"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://schema.inf.com/infOAGIS/2 http://schema.inf.com/2.10.0/infOAGIS/BODs/Developer/SyncPurchaseOrder.xsd"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
releaseID="9.2"
versionID="2.10.0"
/>'

Thanks in Advance.

Answer 1

Hello,

You can use the WITH XMLNAMESPACES (Transact-SQL) command to add namespaces to your xQuery, see Add Namespaces to Queries with WITH XMLNAMESPACES

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Thanks Olaf for your reply. But cant it be achieved using sp_xml_preparedocument?                    

Answer 3

In this case see sp_xml_preparedocument (Transact-SQL) => example "C. Specifying a namespace URI"

---

Olaf Helper

[ Blog] [ Xing] [ MVP]