Getting 'The argument 1 of the xml data type method "modify" must be a string literal' while inserting a attribute in xml

Question

Trying the following code. But getting 'The argument 1 of the xml data type method "modify" must be a string literal' error. searched alot but cant find any solution for this problem

SET @Path = '/@ParentNodeName/@NodeName/child::*'
SET @x.modify('insert attribute status {sql:variable("@status")}
               as first into (' + @Path + ')[1]')

Answer 1

The problem isn't the sql:variable with the value you're trying to insert - it's the way you include the XPath into your modify statement. You cannot string together that command - you need to use a literal:

So you need to use:

SET @x.modify('insert attribute status {sql:variable("@status")}
               as first into (/Parent/Node/)[1]')

Then it works just fine.

Answer 2

CAn I use this in the following way

  SET @x.modify('insert attribute status {sql:variable("@status")} 
           as first into (/@ParentNodeName/@NodeName/child::*)[1]')

PLz suggest

Answer 3

@marc: Do you have any idea if we try to do this by defining the xsd of an existing xml doc and then having dynamic path