I am using SQL Server 2012 in which I have a table
[abc] which has a column called
[Information] of the [XML] type.
This column has values like -
<Information> <Groups> <Group Name="Monitor"> <Items> <Item> <Name>Cid</Name> <Value>2323232323</Value> </Item> <Item> <Name>Tid</Name> <Value>6656565656</Value> </Item> </Items> </Group> </Groups> </Information>
How can I write a SQL Query which can query this column and further extract the value