Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Generate XML with name/value pair using FOR XML RE: Generate XML with name/value pair using FOR XML

  • June 21, 2018 at 1:49 pm

    #1994910

    Torin - Thursday, June 21, 2018 12:43 PM

    Hi Drew,
    you are correct that I missed that change in the code.
    Here are the results with AS [@name]

    <OtherFields>
    <key>
      <_x0040_name>OFcAddress_1</_x0040_name>
      <value>1621 NE Winter</value>
    </key>
    <key>
      <_x0040_name>OFcAddress_2</_x0040_name>
      <value></value>
    </key>

    Is the use of the @ special for the FOR XML? 
    does @name need to be declared?
    thanks!!

    I think it may have something to do with using AUTO instead of PATH.  I almost never use AUTO.  As I mentioned previously, I don't have a SQL instance to work with right now, so I can't test anything.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA