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.

What will be the maximum number of index per table?

950

---

How to generate create function script on an existing function?

1042

---

What are commonly used mssql functions in php?

995

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

139

---

What are the operating modes in which database mirroring runs?

1023

---

Can a table be created inside a trigger?

920

---

Define full outer join?

888

---

Difference between Inner vs outer joins?

892

---

How to download microsoft sql server 2005 express edition?

974

---

How many categories of data types used by sql server?

964

---

Explain system functions or built-in functions? What are different types of system functions?

914

---

Is the order of columns in the set clause important in ms sql server?

925

---

Explain system views?

1020

---

What is an expensive query?

878

---

How to convert numeric expression data types using the cast() function?

1001

---