Parse XML field?

  • jbalbo

    SSCertifiable

    Points: 7456

    Hi

    How would I parse out a value in an XML field

    Say in the XML field below I want to parse out clientid 12345?

    <Parameters xmlns="http://www.website.com/WebFramework/WorkflowParameters.xsd">

    <Parameter Name="ClientID" StringValue="12345" />

    <Parameter Name="ActiveSlide" StringValue="317" />

    </Parameters>

    Thanks

     

  • jonathan.crawford

    SSCertifiable

    Points: 6577

    Check out https://www.sqlservercentral.com/stairways/stairway-to-xml, that should get you started.

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

Viewing 2 posts - 1 through 2 (of 2 total)

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