none
loop through xml nodes in sql

    คำถาม

  • Hi,

     

    I would like to loop through myXml nodes and modify them in sql.

    i have got something like this:

     

    <Root>

      <ValueHolder>

         <Value>3.00</Value>

         <IsNoteDirty>false</IsNoteDirty>

         <Timestamp>

            <StampType>Month</StampType>

            <Stamp>3</Stamp>

            <Year>2007</Year>

         </Timestamp>

         </ValueHolder>

         <ValueHolder>

            <Value xsi:nil="true" />

            <IsNoteDirty>false</IsNoteDirty>

            <Timestamp>

               <StampType>Month</StampType>

               <Stamp>4</Stamp>

               <Year>2007</Year>

            </Timestamp>

         </ValueHolder>

         <ValueHolder>

            <Value>2.00</Value>

            <IsNoteDirty>false</IsNoteDirty>

            <Timestamp>

               <StampType>Month</StampType>

               <Stamp>5</Stamp>

               <Year>2007</Year>

            </Timestamp>

         </ValueHolder>

         <ValueHolder>

            <Value>5.00</Value>

            <IsNoteDirty>false</IsNoteDirty>

           <Timestamp>

              <StampType>Month</StampType>

              <Stamp>6</Stamp>

              <Year>2007</Year>

           </Timestamp>

          </ValueHolder>

    </Root>

     

    And i want to loop over all the "Value" nodes and modify their value.

    How can I do it?

    22 เมษายน 2550 7:25

ตอบทั้งหมด