469,081 Members | 1,789 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

Semistructured data

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.

Jul 23 '05 #1
2 1608
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
--

Jul 23 '05 #2
(mi********************@yahoo.com) writes:
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)?


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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Qiangning Hong | last post: by
1 post views Thread by minimalisticphilosophy | last post: by
reply views Thread by NicK chlam via DotNetMonster.com | last post: by
3 posts views Thread by bbernieb | last post: by
5 posts views Thread by DC Gringo | last post: by
reply views Thread by Winder | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.