Skip to content
Advertisement

insert xml data to table stored procedure sql server

I have xml in following format

I want to insert them in table so the table should have 4 records in the example.

columns are name and alias.

How can I achive this using cursor or something else?

What i have tried. In cursor for entity i try insert alias value,but only first alias is taken.

Advertisement

Answer

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement