in reply to XML data to database
Yeah your post is pretty unreadable.
In general storing XML data in a relational dtabase is not straightforward. XML data is hierarchical which is different from the relational approach. Although most databases have XML import features/support nowadays.
You’re data is very simple though, so something like:
INSERT INTO Person VALUES (department,name,sex,age)
|
|---|