SQL Server 2005 and up make it very easy for you. They have a special XML type and lots of commands to work with XML. Just do a bit of research on this, but XML is the data type you need to use.
>Hi,
>The question - where and how store the XML in SQL database ..
>For example.. in FoxPro I can easy to save XML file in Memo Binary and easy extract it. So I need someting as MEMO field on SQL Server.
>The SQL Server has a type SqlXml.. - is this type using to store XML content on SQL Server?
>How to save and extract it?
>
>Is this way is correct
>Dim loXML as XMLDocument = new XMLDocument
>loXML.load("c:\myxml.xml")
>Dim lcXML as String = loXML.innerXML
>
>and then not possible to store this text in the Sqlxml field.
>
>Where is mistake in my thoughts...
>
>
>P.S. the task is simple.. like in foxpo.. find the record, extract xml text.. and extract information from xml.
>
>Thanks
>Denis
If it's not broken, fix it until it is.
My Blog