Post reply

Update XML tag

  • November 28, 2012 at 10:26 am

    #270709

    Hi,

    Can any one fix this "Incorrect use of the XML data type method 'modify'. A non-mutator method is expected in this context." error ?

    declare @VXML XML

    set @VXML ='<Msg601><IdMessaggio>087132000000102</IdMessaggio><Mittente>BMC</Mittente><IdSistemaGioco>1234567890</IdSistemaGioco><TotBet>0</TotBet><MotivoTrasmissione>0</MotivoTrasmissione><NumRigheB>0</NumRigheB><NumRigheC>15</NumRigheC><NumRigheD>0</NumRigheD><SommaAccantonata>0</SommaAccantonata></Msg601>'

    select @VXML .modify('replace value of (Msg601/IdMessaggio/text())[1] with 10')

    select @VXML

  • November 28, 2012 at 9:12 pm

    #1563550

    Please help us

  • November 29, 2012 at 1:49 am

    #1563604

    change

    select @VXML.modify

    to

    set @VXML.modify

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

  • November 29, 2012 at 3:52 am

    #1563653

    thanks lot

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply