what purpose does OPENXML clause have in sql server stored
procedure?
Answer / 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 |
Explain some stored procedure creating best practices or guidelines?
how to give input dynamically to a insert statement in sqlserver
Whether the updations made to the views reflect the original records in the table
What are number line correlation administrators will use while working with a subquery?
How to find the date and time of last updated table?
How many types of indexes are there in SQL Server?
6 Answers CarrizalSoft Technologies, United Healthcare,
How connect excel to sql server?
what is Covering Index ?
What is mssql?
How to concatenate two strings in SQL Server.
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
what is the diffrence between Snap Shot and Transaction Replication