inserting tag's values of xml into sql2005 table

• afonso_jalmoreira

  Newbie

  Points: 3

  More actions

  September 8, 2011 at 8:08 pm

  #244444

  Hi every body

  I want acess a webservices which send a xmlfiles. anything like that.

  <root>

  <eventos>

  <codigo>1234</codigo>

  <valor>12345></valor>

  </eventos>

  <placa>asd1234</placa>

  <root>

  Inside tag(eventos) codigo/valor may occurs many times

  I ask, how can i find the number of occurrances of tag (eventos)

  before process it??

  How can i find the number of occurrances of tag <eventos> may be 1 or much more. Sorry my bad english i´m from brazil. thanks