xml data to save in database

<i><b>Originally posted by : kumar (kskumar33@hotmail.com)</b></i><br />HI,<br /><br />I would like to know about xml data is updatable as database field. I need to save xml data in to<br />database.<br /><br />Please experts reply to me,<br /><br />Thanks.<br /><br />kumar<br /><br />

<i><b>Originally posted by : David Silverlight (HeadGeek@xmlpitstop.com)</b></i><br />Kumar,<br /> Well, you can definitely go from XML to database with a little bit of translation. In my case, I would use ASP to do the translation. In SQL server 2000, however, you do have the capability of sending an XML string directly to a stored procedure, which would store your data into a table. Also, there is a recent article in XML magazine which describes another approach to saving your XML data to the database. It is an excellent article entitled, "ADO 2.5 embraces the Web", and it is well worth reading.<br /> On the flip side, there are a number of ways to extract the data from the database as pure XML.<br /><br /> Good luck,<br /> David Silverlight<br /> HeadGeek@xmlpitstop.com<br /><br />------------<br />kumar at 6/16/2000 5:29:32 AM<br /><br />HI,<br /><br />I would like to know about xml data is updatable as database field. I need to save xml data in to<br />database.<br /><br />Please experts reply to me,<br /><br />Thanks.<br /><br />kumar<br /><br />