Show result in XML format

We can get select result in format of XML.

SELECT * FROM Employee
FOR XML AUTO, ELEMENTS

Result will be something like this.

When we click on above link result will come as below.

That’s It.
Enjoy Learning.