Get attribute values using xpath in SQL Server 2012

Question

I am using SQL Server 2012. I have the following code

DECLARE @x xml
SET @x = '<labels defaultText = "Javascript">      
            <label text = "Asp" />      
            <label text = "Sql" />      
            <label text = "Wcf" />
          </labels>'

I want to write xpath/xquery query to get all attributes' values named text (in this example - "AspSqlWcf").

Thanks in advance for your help.

Sargis Koshkaryan · Accepted Answer · 2015-04-15 12:53:28Z

2

Try something like this

DECLARE @x xml
SET @x = '<labels defaultText = "Javascript">      
            <label text = "Asp" />      
            <label text = "Sql" />      
            <label text = "Wcf" />
          </labels>'  
SELECT (SELECT 
C.value('@text','nvarchar(100)') 
FROM @x.nodes('labels/label') as T(C)
FOR XML PATH(''),TYPE).value('.','nvarchar(MAX)') as val

edited Apr 15, 2015 at 12:53

Sargis Koshkaryan

1,0403 gold badges9 silver badges19 bronze badges

answered Apr 15, 2015 at 12:35

ughai

9,9004 gold badges33 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Get attribute values using xpath in SQL Server 2012

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