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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only