I've got an XML object. And I want to deserialize it into a table using T-SQL.
<Params>
<type = 1>
<value> 10 </value>
</type>
<type = 2>
<value> abc </value>
</type>
</Params>
How can I store this data into a table like this:
Thanks!
See Question&Answers more detail:os