Interested to Buy Any Domain ? << Click Here >> for more details...
what purpose does OPENXML clause have in sql server stored
procedure?
- 1 Answers
- 5567 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
What is 1nf normalization form?
What program is used to store the data source file?
Explain Geography datatype in SQL Server
Write the SQL query to drop, truncate and delete table.
What is similarity and difference between truncate and delete in sql?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to receive returning result from a query?
whats new about truncate in sql server 2008?
How to create a scrollable cursor with the scroll option?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is a fill factor?
What is SQL Azure Fabric?
How to connect to a sql server using odbc_connect()?
What happens when converting big values to integers?
What is the difference between insensitive and scroll cursor?
