SQL - FOR XML EXPLICIT

DAIR · 22 Sep 2014 at 15:14

Hi

Anyone have any experience with this? Have hit a brick a query that I'm trying to produce.

davetherave2 · 23 Sep 2014 at 22:35

I have some experience with it. I still manage an application that uses sql to xml as it's main data passing process. What specifically do you need help with?

DAIR · 24 Sep 2014 at 07:39

I'm using IDs and IDREFs to nest groups of elements.

The group headings appear as follows
<heading ='element heading'/>

I don't want the value of the ID to be shown. Can it be hidden?

davetherave2 · 24 Sep 2014 at 11:54

well if you don't want the id included in the output then don't include it.

Without seeing how you are building up the xml table (I know of two ways of doing this)
it's difficult to give you the most appropriate answer so if you can provide a sample code example that will help in providing you with an answer.

Nash · 1 Oct 2014 at 03:19

You could obfuscate it by naming the headings something obscure and unrelated but XML is hardly a cryptographically orientated language. Not sure what you mean, I second davetherave2's comments.