parse xml data
I have a xml data passed to the stored procedure like below
</root>. I tried parsing it using node() method but it only works for
one node. I used the following code
person.id.value('.', 'int') as personID
@xml.nodes('/root/id') as person(id)
my question is what do i need to do to return all the three node values at once.
thanks for sugguestions.