Parse XML field?

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  June 9, 2020 at 9:11 pm

  #3761812

  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: 6612

  More actions

  June 9, 2020 at 11:47 pm

  #3761835

  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