Member Avatar for stevestare
stevestare 0 Newbie Poster

I have a data base with multiple Tables, columns and Rows I need to produce an XML file. I'm required to send ALL columns even those that are NILL. In SQL 2005 I can use FOR XML ELEMENTS ISINIL, however I'm using SQL 2000 so I can't get the NILL Columns. Also, I need to change my NODE name to Pular when there is more than one childnode.

What I'm attempting to do is select my database into a data set then write out the data set, using XMLWRITER to a filestream. I need to know can I "insert" or "replace" data in my data set prior to using the XMLWRITER or do I have to re-read (XMLREAD) and then change my data. Or is there a better way?

  • 1 Contributor
  • 0 Replies
  • 59 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.