Answers

Question and Answer:

  Home  SQL Server XML Integration

⟩ What is the OPENXML statement in SQL Server?

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.

 200 views

More Questions for you: