⟩ 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.