Home Forums SQL Server 2008 T-SQL (SS2K8) Replacing self closing tag for empty tag in for XML explicit RE: Replacing self closing tag for empty tag in for XML explicit

  • July 10, 2016 at 5:55 am

    #1889328

    ulisseslourenco (7/7/2016)

    People,

    I have a tsql code with for XML explicit and when there are empty value the code must be <tag><tag/> instead of

    <tag/>, but I didn't know how to implement it using for XML explicit.

    I can't modify the code to other type of XML modes.

    I need help.

    Best regards.

    Out of curiosity, why can't you change the XML mode?

    😎