How can we read a table data in xml Format in SQL Server?

Read this Article it is useful for you

https://www.sqlshack.com/working-with-xml-data-in-sql-server/

SELECT *
FROM YourTableName
FOR XML AUTO, ROOT('Root')