Convert Sql Data Into XML(Security):-

select * from sys.objects FOR XML AUTO,TYPE, ELEMENTS ,ROOT('name')

And vice versa:-
SELECT *
FROM   OPENROWSET('MSDASQL', 
'Driver={Microsoft Text Driver (*.xml)};DefaultDir=C:\Radu\test.xml;',
'SELECT * FROM [test.xml];' )