Post reply

Retrieve XML from Text Column

  • September 23, 2008 at 10:53 am

    #70766

    I have a table in SQL Server 2000 that is defines as a Text column (BLOB) and contains XML string. I need to be able to extract that string from the column what would be the best way to do that?

    Warm Regards,

    Arthur Lorenzini
    Sioux Falls, SD

  • September 25, 2008 at 3:08 am

    #876837

    There is no simple way of doing it in SQL2k, except passing ntext field from external application as parameter to stored procedure and then parsing it using OPENXML.

    If that is not an option, check following article where the tricky solution is provided:

    http://www.informit.com/articles/article.aspx?p=102307&seqNum=16

    Cheers, Max

    Check-out free open-source utility Sql Server Replication Explorer[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply