none
Update signed type xml column

    Question

  • What is the syntax to update the value 121212 to another field's value within the same table? The column has this when clicked on: 

    <DocumentElement>
      <TestData>
        <TestID>5</TestID>
        <TestCategoryID>800</TestCategoryID>
        <Value1>121212</Value1>
      </TestData>
    </DocumentElement>

    I think it has to be something similiar to:

    UPDATE t
    SET field1.modify(
    ('/DocumentElement/TestData[TestCategoryID[1]="800"]').value('TestData[1]/Value1[1]', 'varchar(100)')
    replace value of


    Barret

    Friday, February 10, 2012 3:34 PM

All replies