Populate an existing XML file with SQL data

• TJ_T

  Old Hand

  Points: 352

  More actions

  March 7, 2019 at 10:37 am

  #104562

  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

  Ten Centuries

  Points: 1240

  More actions

  March 8, 2019 at 1:57 am

  #2023917

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

• Eirikur Eiriksson

  SSC Guru

  Points: 182942

  More actions

  March 8, 2019 at 3:46 am

  #2023923

  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?