How to get string between XML element in MS SQL
Today we will see
how to get only the string between XML element from MS
SQL database. Sometimes we may save the data in XML format in such
situation this query will be helpful.
Here I have only two element as sample, you may extend the
XML based on the XML file you have in your application.
DECLARE @ProductDetails NVARCHAR(MAX), @XML XML
SET
@ProductDetails='<Product>WD Hard Disk
</Product><Description>1TB Passport
Essential</Description>'
SET @XML = CONVERT(XML,
@ProductDetails)
SELECT @XML.query('.').value('.',
'VARCHAR(1000)')
Out put of the above query will be: "WD Hard Disk 1TB Passport Essential"