I have following XML stored in a XML column in a SQL Server database.
<?xml version="1.0" encoding="UTF-8" ?>
<ns0:Root>
<ns0:Result>
<ns0:AStatus>Aaa</ns0:AStatus>
<ns0:BStatus>Bbb</ns0:BStatus>
</ns0:Result>
</ns0:Root>
I'd like to get value "Aaa", by firing SQL query.
No comments:
Post a Comment