主页 / dba / 问题 / 30391
Accepted
Ario
Asked: 2012-12-14 09:02:52 +0800 CST

如何将xml转换为数据库表

  • 772

输入：

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 个回答

  1. Best Answer

    很接近：

    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

相关问题