CODEWITHSUNDEEP
sql-serverxmlsql-server-2008xqueryxquery-sql
ca9163d9
ca9163d9

Reputation: 29159

Sql server xquery returning element name

I have the following xml

declare @xml xml = '<Values><a>AAA</a><b>BBB</b></Values>';
select @xml.query('for $k in /Values return concat(",@", "=''", $k, "''")')

It returns

,@='AAABBB'

However I expect

,@a='AAA',@b='BBB'

How to write the xquery?

Upvotes: 0

Views: 678

Answers (1)

ca9163d9
ca9163d9

Reputation: 29159

I figured it out myself.

declare @xml xml = '<Values><a>AAA</a><b>BBB</b></Values>';
select @xml.query('for $k in /Values/* 
    return concat(",@", fn:local-name($k), "=''", $k, "''")')

Upvotes: 2

Related Questions