Using XQuery in SQL Server 2005 to get XML Inner Text

Question

How do I select the inner text of an XML node using XQuery?

Microsoft Books Online shows how to retrive an attribute below:

DECLARE @myDoc xml
DECLARE @ProdID int
SET @myDoc = '<Root>
<ProductDescription ProductID="1" ProductName="Road Bike">
<Features>
  <Warranty>1 year parts and labor</Warranty>
  <Maintenance>3 year parts and labor extended maintenance is available</Maintenance>
</Features>
</ProductDescription>
</Root>'

SET @ProdID =  @myDoc.value('(/Root/ProductDescription/@ProductID)[1]', 'int' )
SELECT @ProdID

How would I get the inner text value of the Warranty node?

marc_s · Accepted Answer · 2013-09-25 04:56:17Z

6

Something like this:

DECLARE @Warranty VARCHAR(50)

SET @Warranty = @myDoc.value('(/Root/ProductDescription/Features/Warranty/text())[1]', 'varchar(50)' )

SELECT @Warranty

Marc

edited Sep 25, 2013 at 4:56

answered Mar 9, 2009 at 16:58

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using XQuery in SQL Server 2005 to get XML Inner Text

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related