How to Convert SQL Data to XML

In this blog we will see how to convert SQL table data to XML using a SQL Query.

I have a sample Employee table. We will fire a select query to check data in the table.

select * from employee

The following is the data in the table.



Now we will see how to convert this data in XML.

Write down the below query in the Query Analyser.

select * from employee for xml raw

Let us check the output now.



Click on the XMl generated. And in a new window we get the following XML resultset.