TEXT deprecated? I hadn't heard that. Thanks.

>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