CODEWITHSUNDEEP
sqlsql-serverxmldatabasesqlxml
gkarya42
gkarya42

Reputation: 429

Create XML from Sql query

How to create XML in below format from SQL Query in SQL Server?

<ROOT><ELEMENT>VALUE1</ELEMENT></ROOT>
<ROOT><ELEMENT>VALUE2</ELEMENT></ROOT>
<ROOT><ELEMENT>VALUE3</ELEMENT></ROOT>

Upvotes: 0

Views: 2077

Answers (2)

Andrey Korneyev
Andrey Korneyev

Reputation: 26896

You can do it something like:

select T.Element as 'Element'
from 
(
    select 'VALUE1' as Element
    union all 
    select 'VALUE2'
    union all 
    select 'VALUE3'
) as T
for xml path('ROOT')

See MSDN for more information.

Upvotes: 1

j.v.
j.v.

Reputation: 997

 SELECT t.value AS ELEMENT          
     FROM [dbo].tbl t
     FOR XML PATH ('ROOT');

Upvotes: 1

Related Questions