Loading

How to read xml nodes data

Venkatesh Pettem

7y784

I'm trying to read xml node in sql server, i couldn't able to read the node data, can any one help me,

Below is xml Content:

The bold node im not able to read. Below im trying in sql server

select

Code = x.v.value('(code/@code)[1]', 'VARCHAR(100)') ,

DispositionCode= x.v.value('(------?-------)[1]', 'VARCHAR(100)')

FROM @XMLValue.nodes('entry/entryRelationship/encounter') x(v)

1 Reply
Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sign inCreate an account

GUGuest User7y agoPosted Jul 2, 2019, 4:54 AM Accepted answer You will have to include a namespace to access that node. See this SO thread : https://stackoverflow.com/questions/22818591/sql-server-xml-query-with-multiple-namespaces