Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-13 : 08:02:25
|
| Jo writes "SQL server 2000 has some XML support, but what if I have a complex XML document that I need to update and search. I could shred it and place everyhing in a relational database structure, then do my updates and put together the XML document when needed.Is it possible to store the XML document as a "flat" document in the database and still perform update and search operations from within the SQL server? I have not found any way to do this and I dont think SQL server support this.Any suggestions would be welcome!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-01-13 : 08:07:39
|
quote:
I could shred it and place everyhing in a relational database structure, then do my updates and put together the XML document when needed.
This is the best thing to do if you are going to put the data into a database at all.quote:
Is it possible to store the XML document as a "flat" document in the database and still perform update and search operations from within the SQL server?
"Possible", yeah, well maybe. "Desirable", absolutely not. Way too much overhead will be involved.quote:
I have not found any way to do this and I dont think SQL server support this.
There will be more support for XML data in Yukon (the next version of SQL Server), but the differences between relational and XML data structures really do not allow them to work well together. XML is a nice intermediate format for exchanging data, it is not as rich or robust for storing, manipulating, or searching as relational databases are. Storing XML in a relational database is like storing eggs in a whisky jug. |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2004-01-14 : 01:55:53
|
Nice Analogy Rob quote:
Storing XML in a relational database is like storing eggs in a whisky jug.
-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
|
|
|
|
SQL Server and XML updates