Return data in XML format in SQL Server

if you want to return you data in XML you can just simply put this line in the end after you query

 FOR XML RAW ('ABC'), ELEMENTS ;