In my application database, customer order information is stored as xml in a nvarchar field in sql server.
I want to extract all orders which are valued more than 1000. Please find the below sample xml and help me with the query.
Sample xml
In my application database, customer order information is stored as xml in a nvarchar field in sql server.
I want to extract all orders which are valued more than 1000. Please find the below sample xml and help me with the query.
Sample xml
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.
AniPosted Apr 13, 2022, 1:35 PM
Imran,
I need query at SQL side
Muhammad Imran AnsariPosted Apr 13, 2022, 10:27 AM