Two questions about moving data between a SQL DB and XML

1) I am exporting data from a SQL DB to an XML file. It works great but it
appears that null data in database records does not get put into the XML.
Is there a way to force it to always put the null data there instead of
omitting it?

2) How do I insert the data back into the SQL DB from the XML file?


.

Relevant Pages

  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... XML file from the following location - mssecure.xml Possible ... and on a NT 4 Server, but the scanner works fine on a W2K Server ...
    (Focus-Microsoft)
  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... seems so far that the patches it suggests are accurate. ... it the patch for advisory MS01-015 is not istalled, ... verison of the binary or the xml file at any of the URLs I've been given. ...
    (Focus-Microsoft)
  • Re: ADO.NET questions
    ... Sure, you can use XML to move data to and from SQL Server, but it's very ... >>> have a way to export rows from a few tables from one users computer to ... >>> email xml file to another user) ... >>> 5)Create SQLDataAdapter on target computer. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Looking for database design/model software
    ... > generate SQL, ... Since Dia ... I actually have a small PHP script that takes the input of ... feed it into another script that turns it an XML file for Dia. ...
    (RedHat)
  • Re: OO vs. RDB challenge
    ... >> strict adherence only to the SQL oriented challenge? ... The groups XML file may change in structure, new fields may appear, old ... schema doesn't map easily to systems requiring a more rigid schema. ...
    (comp.object)
Loading