How the select all value xml column ?true City Found AL Billingsley Montgomery 11 Clear 47 83 CALM 30.19F Loading
How the select all value xml column ?true City Found AL Billingsley Montgomery 11 Clear 47 83 CALM 30.19F 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.
Jignesh TrivediPosted Nov 14, 2013, 1:27 AM
hi,
I guess you want node value from XML data type. with the help of value() method you can get the value of node.
Please refer
http://technet.microsoft.com/en-us/library/ms178030.aspx
hope this will help you.
HanookPosted Nov 14, 2013, 6:44 AM
http://sqlwithmanoj.wordpress.com/xml-sql/
Sinan EGEPosted Nov 14, 2013, 1:03 AM
Jignesh TrivediPosted Nov 13, 2013, 11:43 PM
what exactly are you looking for xml data type in sql server