How to insert data in multilple tables from xml file in sql?

Question

how to read xml file and insert data in multiple tables from xml file in sql server 2008?

Vithal Wadje · Answer

try this one CREATE PROCEDURE SaveUserDetails @UserDetXML XML AS BEGIN INSERT INTO UserDet (Namecity) SELECT User.record.query('Name').value('.' 'varchar(50)') User.record.query('City').value('.' 'varchar(100)') FROM @UserDetXML .nodes('ArrayOfUserDetail/UserDetail') AS UserData(record) END