Sample - Script in SQL Server to Export and Import in XML

--// Sample - EXPORT to XML
========================================= 
SELECT [UsuNome] AS "Nome"
,[UsuSobrenome] AS Sobrenome
,[UsuEmail] AS Email
FROM [tbUsuarios] AS Usuarios
FOR XML PATH('UsuariosGerais')
 
--// Result:
<row Nome="Leandro"><Sobrenome>Buffone</Sobrenome><Email>leandro@w1net.com.br</Email></row>
<row Nome="Suporte"><Sobrenome>Online</Sobrenome><Email>suporte@w1net.com.br</Email></row>
 
 
--// Sample - IMPORT from XML
=========================================
SELECT X.UsuariosGerais.query('Nome').value('.', 'CHAR(14)'), 
X.UsuariosGerais.query('Sobrenome').value('.', 'VARCHAR(50)'), 
X.UsuariosGerais.query('Email').value('.', 'VARCHAR(50)') 
FROM ( SELECT CAST(X AS XML) 
FROM OPENROWSET( BULK 'C:\Temp\sample.xml', SINGLE_BLOB) AS T(X) 
 ) AS T(X) 
CROSS APPLY X.nodes('UsuariosGerais') AS X(UsuariosGerais);