(Abey George) In order to get the data in XML format you need to change the select statement. You can use the FOR XML clause of select statement. Format of FOR XML is given below.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help