xml Modify() Method

• tpa-788678

  SSC Rookie

  Points: 40

  More actions

  July 1, 2008 at 11:01 am

  #193942

  I´m trying to modify proxysimultaneous atributte, but something is not going well what i'me doing wrong?

  Can anyone help me ?

  declare @i int

  declare @teste xml

  set @i=23

  set @teste='

  '

  set @teste.modify('replace value of

  (proxy/@proxysimultaneous="2"]

  with sql:variable("@i")')

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  July 25, 2008 at 5:40 am

  #848317

  Please, attach the XML sample to the post, and post the query again.

  The query you posted does not seem to be the actual query. Perhaps it was mangled by the post editor. Mark it as code and try again, or attach it.

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com