I have the following xml\[code\]declare @xml xml = '<Values><a>AAA</a><b>BBB</b></Values>';select @xml.query('for $k in /Values return concat(",@", "=''", $k, "''")')\[/code\]It returns\[quote\] ,@='AAABBB'\[/quote\]However I expect \[quote\] ,@a='AAA',@b='BBB'\[/quote\]How to write the xquery?
Sql server xquery returning element name
- Thread starter Hamberger
- Start date