Post reply

Extract from xml stored as a varchar in a database

  • April 10, 2013 at 2:50 pm

    #270952

    Hello everyone,

    I need to extract information form xml stored in a database and store the extracted information

    to another database. The xml is stored as varchar.

    Is there any good way to extract the information from the database ?

  • April 10, 2013 at 3:08 pm

    #1605413

    Take a look at this thread:

    Identify node and tag in XML data using T-sql

    I think you are asking the same thing as the poster in that thread and there's some good examples. Extracting data from XML can make you crazy! If these methods don't meet your needs or patience level, you should look into XQUERY (which is no piece-of-cake either).

     

     

  • April 10, 2013 at 3:40 pm

    #1605420

    If Steven's link doesn't help you, post a sample XML document and some DDL. We can help you extract the data.

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

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