Re: Transform XML to Database
Monday, May 20, 2002 12:59 AM
If u r using SQL Server 2002 then there is no need to worry.
SQL S2002 automatically creates tables and load xml data inot these tables.
It maps element name into table name and attributes of element into table columns.
It can also return data in form of xml structure which is stored in tabular form in relational db.
If u r not using SQL S2002 but u can follow its mapping approach to perform ur task.
XSLT is best source to acheive this goal.
I think that it would help u.