sql server (alternate): Does SQL Server support the semi-structured data model?

How can XML documents storage and retrieval be efficiently exploited on
SQL Server?

Where can I find more info on the semistructured data model
implementation on SQL Seerver (if any)?

Thank you.

SQL Server provides various interfaces for XML data, such as OPENXML
for querying XML documents and the FOR XML option for XML output.

However, SQL Server 2000 doesn't have any native support for XML-based
data storage. Unless you want to store your data in relational form
then there probably isn't much reason to put it in SQL Server in the
first place. This is still SQL Server, not XML Server (yet!) :-)

--
David Portas
SQL Server MVP
--

(minimalisticphilosophy@yahoo.com) writes:
[quoted text, click to view]

To add to David's answer: in SQL 2000, you can store XML documents
in ntext columns, and you can retrieve data from them with the
OPENXML rowset function.

In the next version of SQL Server, SQL Server 2005, which currently is
beta, there is an XML datatype, and you can query XML documents directly
with XQuery.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at