Populate an existing XML file with SQL data

  • TJ_T

    SSC Enthusiast

    Points: 133

    Hi, is it possible to populate an existing XML file with SQL data?  If so, how?  There are only a few parts of the XML file I want to populate.

    Thanks

  • jonas.gunnarsson 52434

    SSC Eights!

    Points: 946

    Look at insert (XML DML), there is some samples that may fit your needs.

  • Eirikur Eiriksson

    SSC Guru

    Points: 182318

    TJ_T - Thursday, March 7, 2019 10:37 AM

    Hi, is it possible to populate an existing XML file with SQL data?  If so, how?  There are only a few parts of the XML file I want to populate.

    Thanks

    Can you post a before and after samples of the XML, DDL (create table) script and sample data as an insert statement please?
    😎

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

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