MS SQL Server XML Integration Interview Question:

What is the OPENXML statement in SQL Server?

Submitted by: Administrator

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.
Submitted by: Administrator