Select in dynamic XML returning all possible values within the tags - SQL SERVER

Asked

Viewed 23 times

0

i wonder if it is possible to select in an XML bringing all possible results within select and stored in a variable

XML:

<Nome>@PartyId</Nome><Nome>@CallId</Nome>

The tag <Nome> will always come, but I need to store all the values that come within these tags by concatenating them into a variable like this :

DECLARE X VARCHAR(MAX)
SET X = '@PartyId @CallId'
  • yes is possible using nodes to filter

  • could you give me some example please ? @Ricardopunctual

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.