MS SQL Server XML Integration Question:
What is the OPENXML statement in SQL Server?
Answer:
OPENXML is a row set provider, in which a row set view over an XML documented is provided. It is used to parse the complex XML function.
Syntax:
OPENXML(idoc int [in],rowpattern nvarchar[in],[flags byte[in]]) [WITH (SchemaDeclaration | TableName)]
Idoc is the document handle of an XML document which is created by calling sp_xml_preparedocument
Xpath is the pattern used to identify the nodes.
Flag is for mapping between the XML data and the relational rowset
WITH clause is used to provide a rowset format.
Syntax:
OPENXML(idoc int [in],rowpattern nvarchar[in],[flags byte[in]]) [WITH (SchemaDeclaration | TableName)]
Idoc is the document handle of an XML document which is created by calling sp_xml_preparedocument
Xpath is the pattern used to identify the nodes.
Flag is for mapping between the XML data and the relational rowset
WITH clause is used to provide a rowset format.
| Previous Question | Next Question |
| What is FOR XML in SQL Server? | How to call stored procedure using HTTP SOAP? |