I have a sample Employee table. We will fire a select query to check data in the table.
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
![]()
Click on the XMl generated. And in a new window we get the following XML resultset.
![]()