SQL Server : FOR XML set root attribute

Question

How do you set the root attribute to a column in a FOR XML in SQL Server?

For instance, if you have 3 columns like 'First Name', 'Last Name', and 'Person' and you wan the output to be something like

<root type="person">
    <first Name/>
    <last name/>
</root>

Eli · Accepted Answer · 2017-05-01 19:06:55Z

1

Try the following:

select 
    'person' as '@type'
    /*
    rest of stuff goes here...
    */
From someTable
FOR xml path('root')

answered May 1, 2017 at 19:06

Eli

2,6182 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1