I am using XQuery in
in my project. I need to retrieve multiple elements located in different places in the document and I need the retrieved elements in the document order.
My program should work with any XML file so I do not have a specific structure. It is just a function that gets multiple XPath expressions and return the retrieved elements in the document order.
Assuming the previous xml is stored in column x in Table.
') as result
from Table where ID =1
the previous query will return the elements in the order they have in the query not the order they have in the document, the result is
When retrieving multiple elements using one Xpath expressions, SQL serve
View Complete Post