If you have AdventureWorks DB installed then try to use SQL statement to learn producing XML output :
USE AdventureWorks
SELECT
(
SELECT TOP 2
'AdventureWorks' AS '@Table'
,'E' AS '@ChangeType'
,'ContactID' AS 'Column/@Name'
, c.ContactID AS 'Column/*'
, NULL
,'FirstName' AS 'Column/@Name'
, c.FirstName AS 'Column/*'
, NULL
,'LastName' AS 'Column/@Name'
, c.LastName AS 'Column/*'
, NULL
,'Phone' AS 'Column/@Name'
, c.Phone AS 'Column/*'
, NULL
FROM Person.Contact c
ORDER BY ContactID
FOR XML PATH('DataRow'), Type
)
FOR XML PATH('Root')
Hope it helps.