How to store xml files in db - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to store xml files in db

Author

Topic

GuruC
Starting Member

1 Post

Posted - 2007-01-16 : 00:44:43

Hi All,

Please let me know how to store xml files in the db and retrieve data from them.

I want to create a table like this:

Column_name type
some_id long
some_metadata xmlFile

I want to store a xml file in the metadata column and retrieve data from it when needed given the id.

Please help.

--Guru

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-16 : 01:24:02

Use either TEXT or IMAGE, as suggested in Books Online.

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources