what purpose does OPENXML clause have in sql server stored
procedure?
- 1 Answers
- 5716 Views
- I also Faced
- E-Mail Answers
Answer Posted / p.rajesh
OPENXML, a Transact-SQL keyword, provides a rowset over in-
memory XML documents that is similar to a table or a view.
OPENXML allows access to XML data as though it is a
relational rowset. It does this by providing a rowset view
of the internal representation of an XML document. The
records in the rowset can be stored in database tables.
OPENXML can be used in SELECT and SELECT INTO statements
wherever rowset providers, a view, or OPENROWSET can appear
as the source. For information about the syntax of OPENXML,
see OPENXML (Transact-SQL).
To write queries against an XML document by using OPENXML,
you must first call sp_xml_preparedocument. This parses the
XML document and returns a handle to the parsed document
that is ready for consumption. The parsed document is a
document object model (DOM) tree representation of various
nodes in the XML document. The document handle is passed to
OPENXML. OPENXML then provides a rowset view of the
document, based on the parameters passed to it.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Why we use the openxml clause?
How can we solve concurrency problems?
Equi join and non equi join is possible with sql server?
How can I check that whether automatic statistic update is enabled or not?
Disadvantages of the indexes?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Why and when do stored procedure recompile?
How to connect php with different port numbers?
What is acid mean in sql server?
What is subquery? Explain the properties of a subquery?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the properties of the transaction?
How to convert numeric expression data types using the cast() function?
Can you index views?
