Denis,

I have stored XML in SQL Server simply as a "text" data type (I guess MS is deprecating that data type in favor of "VARCHAR(MAX)", but it's still the same thing). This is comparable to a "memo" field in FoxPro.

~~Bonnie



>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