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 does Master database contains?

1179

---

How can we delete a table in sql server?

1016

---

What is the use of nvl work?

1043

---

What is a domain constraint give an example?

1103

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1002

---

What is raid? : SQL Server Architecture

1223

---

What is nested transaction?

1132

---

What are page splits?

1047

---

What is the significance of null value and why should we avoid permitting null values?

1029

---

What is difference between rollback immediate and with no_wait during alter database?

1129

---

What is the difference between commit and rollback?

985

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1210

---

What are the types of containers in ssis?

1229

---

What is exporting utility?

1082

---

Can an entity have two primary keys?

1027

---