What is the OPENXML statement in SQL Server?
Submitted by: AdministratorOPENXML 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
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
Read Online MS SQL Server XML Integration Job Interview Questions And Answers
Top MS SQL Server XML Integration Questions
☺ | What is the OPENXML statement in SQL Server? |
☺ | What is FOR XML in SQL Server? |
☺ | What are XML indexes? |
☺ | How to call stored procedure using HTTP SOAP? |
☺ | What is XMLA? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |