Início / dba / Perguntas / 30391
Accepted
Ario
Asked: 2012-12-14 09:02:52 +0800 CST

como converter xml para tabela de banco de dados

  • 772

entrada:

Declare @OUT xml
select @OUT = N'
<row>
  <kind>MainCat</kind>
  <sortid>1</sortid>
  <kind_id>1</kind_id>
  <PPoet>حافظ</PPoet>
  <MTitle>حافظ</MTitle>
  <Row>1</Row>
</row>'


select T.X.value('@Kind', 'nvarchar(50)') as kind,
T.X.value('@sortid', 'int') as sortid
from @out.nodes('/row') as T(X)

this select return NULL!
sql-server sql-server-2008

1 respostas

  1. Best Answer

    Muito perto:

    select 
  T.X.value('./kind[1]', 'nvarchar(50)') as kind,
  T.X.value('./sortid[1]', 'int') as sortid
from @out.nodes('/row') as T(X);
    • 4

relate perguntas