Re: modify() Top-level attribute nodes are not supported Error

On Apr 6, 8:50 pm, Kent Tegels <kteg...@xxxxxxxxxxx> wrote:
Hello BradR,

The sql:variable() function is what you'd need to resolve @xUpdate in your
query (remember that @xUpdate is an attribute in XQuery). That said, if you
try this:

set @xPerson.modify('insert sql:variable("@xUpdate") into /person[1]')

You'll be sadly disappointed. You can't use the sql:variable function to
inject XML into XML. And converting xUpdate to nvarchar(...) isn't going
to help you either for less obvious reasons.

IMHO don't use XMLDML for this, its just too much of a PITA. You're better
off you write a SQLCLR function that does the insert for you.

Your milage may vary.

Thanks!
Kent Tegels
DevelopMentorhttp://staff.develop.com/ktegels/

I've been investigating this for a while. It looks like it's possible
to solve this problem with FOR XML EXPLICIT, but that looks really
messy. Can you point me to a useful SQLCLR example?

Thanks!

.

Relevant Pages