Kalai

Kalai

  • NA
  • 378
  • 17.1k

Dynamic XML to Table

Dec 2 2014 12:59 AM

I am passing table name and XML string to Sql Server SP. I want to insert records to corresponding table. how to read the column name dynamically?


Example : 1
===========
Declare @TableName = 'Table1'
Declare @xml1 xml
set @xml1 = '<Root>
 <Nodes>
  <Id>01</Id>
  <Name>Mike</Name>
 </Nodes>
</Root>'

insert into @TableName (
--column names from @xml
) values
(
 --select ID from @xml,
 --select Name from @xml
)

Example : 2
===========

Declare @TableName = 'Table2'
Declare @xml2 xml
set @xml2 = '<Root>
 <Nodes>
  <EmpId>05</EmpId>
  <EmpName>Andrew</EmpName>
 </Nodes>
</Root>'


Answers (2)