Attempting To Modify XML in SQL Server Using XQuery

Question

I am attempting to add an attribute to a node in an XML column in SQL Server.

UPDATE
    TableName
SET Metadata.modify('
    insert attribute MyAttribute{"01b9cd0b-bfed-436f-bc58-57d2fddd9211"}
    into (Root/Collection/Item[@No="360"][1])
')
WHERE
    TableName.Id = 1

I get the following error...

Msg 2226, Level 16, State 1, Line 4 XQuery
[TableName.Metadata.modify()]: The target of 'insert' must be a single node, found 'element(Item,xdt:untyped) *'

But I thought my selection would return a single item, given the [1]

Fenton · Accepted Answer · 2013-02-22 11:22:46Z

2

Stupid XQuery! (Or possibly me).

You need to place the [1] outside of the brackets:

into (Root/Collection/Item[@No="360"][1])

Should be

into (Root/Collection/Item[@No="360"])[1]

answered Feb 22, 2013 at 11:22

Fenton

253k74 gold badges403 silver badges413 bronze badges

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

Collectives™ on Stack Overflow

Attempting To Modify XML in SQL Server Using XQuery

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related