[DotNetDevelopment] How I Import or Insert a XML file into SQL Server 2008?

[Otavio Alfenas]

Hi Folks,

I Have a XML file and I Would like to insert in one of into table of
SQL.
But i cannot to use the BULK method.

I would like to do directly by procedure or via programming in vb

Someone help me?

Obs: This xml can contain thousands of fields.

XML:

EXEMPLE:

<PRINCIPAL>

  <INICIO_NODE>

    <NODE1>Teste</NODE1>

    <NODE1>Teste</NODE1>

    <NODE1>Teste</NODE1>

  </INICIO_NODE>

  <INICIO_NODE2>

    <NODE2>Teste2</NODE2>

    <NODE2>Teste2</NODE2>

    <NODE2>Teste2</NODE2>

  </INICIO_NODE2>

</PRINCIPAL>


Thank's a lot