1

In SQL Server 2008, I would like to insert some elements and values into a specific child element of an xml column based on the value of another of that element's children (ID in this case). The xml currently looks like this: 

<Profile>
  <ID>16</ID>
  <User>
    <ID>BC4A18CA-AFB5-4268-BDA9-C990DAFE7783</ID>
    <Name>test</Name>
    <Activities />
  </User>
</Profile>

However, there could potentially be multiple <User> elements within the xml, and I need to insert only into the <User> of a specific <ID> value. How can I achieve this in MS SQL Server 2008/ t-sql?

Edit: To simplify, I am grabbing the xml from that column and setting it to a variable:

DECLARE @profiles_xml xml
DECLARE @profile_id int
SET @profile_id = 16
SET @profiles_xml = (SELECT profiles from tbl_applied_profiles WHERE
profiles.value('(Profile/ID)[1]','int')= @profile_id)

The resulting xml value of @profiles_xml looks like what I have above.

Improve this question
1
Related questions
3
Insert XML into SQL Table XML column
1
Insert Into with XML Field to get all Values of a Child Element?
1
Inserting multiple child elements from XML into SQL Server database
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.