Post reply

Generate XML File

  • February 16, 2016 at 11:59 am

    #399731

    Hi i need to generate a XML file like this

    <Products>

    <product>item1</product>

    <product>item2</product>

    <product>item3</product>

    <product>item4</product>

    <product>item5</product>

    </Products>

    i have this query

    select Product

    from Products

    where category= 1

    i try to use FOR XML AUTO or FOR XML PATH and i don't have the xml what i needed ...

    any suggest ?

  • February 16, 2016 at 12:05 pm

    #1859061

    i'm find the solution, i need to use FOR XML PATH('')

    😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply