XML adding

• cooljagadeesh

  SSC Eights!

  Points: 959

  More actions

  October 5, 2012 at 8:33 pm

  #282700

  Hi i have a small doubt

  DECLARE @XML XML='<ROOT>

  <ITEMS PID="0" FN="DEFAULT " LN="DEFAULT" />

  <ITEMS PID="1" FN="HARISH" LN="SINGH" />

  </ROOT>'

  select @XML

  how to add additional values GID,TID to the existing xml

  i want output like this

  <ROOT>

  <ITEMS PID="0" FN="Default " LN="Default" GID="1" TID="42" />

  <ITEMS PID="1" FN="HARISH" LN="SINGH" GID="1" TID="42" />

  </ROOT>

• demonfox

  SSCertifiable

  Points: 6289

  More actions

  October 5, 2012 at 9:47 pm

  #1546372

  Just and example:

  declare @var int = 40

  DECLARE @XML XML='<ROOT>

  <ITEMS PID="0" FN="DEFAULT " LN="DEFAULT" />

  <ITEMS PID="1" FN="HARISH" LN="SINGH" />

  </ROOT>'

  SELECT @XML

  SET @XML.modify('

  insert attribute GID {sql:variable("@var") }

  into (/ROOT/ITEMS)[1] ')

  SELECT @XML

  Edited : check out the msdn for inserting xml nodes, attributes and elements..

  http://msdn.microsoft.com/en-us/library/ms175466.aspx

  ~ demonfox
  ___________________________________________________________________
  Wondering what I would do next , when I am done with this one :ermm: