Semistructured data - Microsoft SQL Server

minimalisticphilosophy

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

Subscribe Reply

1705

David Portas

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

Erland Sommarskog

(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

Similar topics

2254

how to advance a database resource pointer to the next row in the returned data?

by: lawrence | last post by:

I had some code that worked fine for several weeks, and then yesterday it stopped working. I'm not sure what I did. Nor can I make out why it isn't working. I'm running a query that should return 3 items from the database. I then get a count of the return, which correctly tells me that I've got 3 items. I then go into a for loop which I expect...

PHP

1876

collect data using threads

by: Qiangning Hong | last post by:

A class Collector, it spawns several threads to read from serial port. Collector.get_data() will get all the data they have read since last call. Who can tell me whether my implementation correct? class Collector(object): def __init__(self): self.data = spawn_work_bees(callback=self.on_received) def on_received(self, a_piece_of_data):

Python

1142

Semistructured data in DB2

by: minimalisticphilosophy | last post by:

I'd like to know whether or not DB2 supports the semistructured data model. Does DB2 provide any funcionalities to store and operate on semistructured data? How can XML documents be stored and exploited on DB2? Thank you for any help.

DB2 Database

5623

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in sy

by: NicK chlam via DotNetMonster.com | last post by:

this is the error i get System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.Common.DbDataAdapter.Update(DataRow dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet) at...

ASP.NET

2043

Data Binding Question

by: bbernieb | last post by:

Hi, All, Is it possible to access a variable inside of a data binding, without the variable being out of scope? (Note: On the DataBinder line, I get an error message that says "Name 'i' is not declared". The data bind is for a DataList.)

ASP.NET

2213

Can I get the data using sql command???

by: Gene | last post by:

What can I do if I want to get the result using the sql command? for example, the select command is "select Name from Employee where StaffID=10" How to get the "Name"??? dim Name as string and then..... what should I do?

Visual Basic .NET

1782

sqladapter caching data?

by: DC Gringo | last post by:

I am having a problem reading a simple update to the database. Basically I'm testing a small change to the pubs database -- changing the price of the Busy Executive's Database Guide from 19.99 to 1997 and back. Unfortunately, it seems does reflect the change on my web form. Perhaps it's caching the data retrieved by the SQLDataAdapter? ...

Visual Basic .NET

14602

How to get the data from an ObjectDataSource in a custom control

by: Rolf Welskes | last post by:

Hello, I have an ObjectDataSource which has as business-object a simple array of strings. No problem. I have an own (custom) control to which I give the DataSourceId and in the custom-control so I get the ObjectDataSource. No problem ..... ObjectDataSource src = .... //is ok i have it

ASP.NET

2055

Computer Data Recovery

by: Winder | last post by:

Computer Data Recovery Help 24/7 Data recovering tools and services is our focus. We will recover your data in a cost effective and efficient manner. We recover all operating systems and media. Call for a free consultation. http://a.uuload.com/Computer-Data-Recovery.htm LiveVault's Online Recovery Service Protect vital data with...

ASP.NET

7276

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7182

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7142

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5110

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

4773

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3259

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1624

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

825

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

488

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General