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