Tuesday, 17 February 2015

How can I query a value in SQL Server XML column in SQL Server 2008



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