Insert records into multiple tables

1

Hi ,

Could somebody tell the best way to insert records into multiple tables from a XML doc(all the tables are related 1-n relationship).

Thanks in Advance,
Anu

2

Hi,
If you are using SQL server, you can create a stored procedure to insert data in the xml document to multiple tables. I am not sure which other DB has this functionality.
Another way is to do multiple execsql statements to do a manual insert into multiple tables.
Good Luck!