xml如何导入sqlserveer

[w56099774]

有很多，怎么导入到sqlserver中？
xml里面数据是这样的
<?xml version="1.0" encoding="UTF-8" ?>
- <extraction>
<clueid>16989298</clueid>
- <fullpath>
- <![CDATA[ http://www.chemicalbook.com/ProductMSDSDetailCB6288989.htm
]]>
</fullpath>
<theme>MSDS-list-17</theme>
<middle>default</middle>
- <baseURI>
- <bucketBaseURI>
<bucketName>deta</bucketName>
- <uri>
- <![CDATA[ http://www.chemicalbook.com/ProductMSDSDetailCB6288989.htm
]]>
</uri>
</bucketBaseURI>
</baseURI>
- <detail>
- <item>
<中文名称>【中文名称】戊烷</中文名称>
<英文名称>【英文名称】n-pentane</英文名称>

[--小F--]

http://www.cnblogs.com/huashanlin/archive/2007/02/09/645734.html

[dawugui]

导入 xml　文件

DECLARE @idoc int
DECLARE @doc varchar(1000)
--sample XML document
SET @doc ='


Customer was very satisfied


Important
Happy Customer.


'
-- Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

-- Execute a SELECT statement using OPENXML rowset provider.
SELECT *
FROM OPENXML (@idoc, '/root/Customer/Order', 1)
WITH (oid char(5),
amount float,
comment ntext 'text()')
EXEC sp_xml_removedocument @idoc

[苦逼的程序员]

+1[Quote=引用 1 楼 dawugui 的回复:]

导入 xml　文件

DECLARE @idoc int
DECLARE @doc varchar(1000)
--sample XML document
SET @doc ='


Customer was very satisfied


Important
Happy Customer.


'
-- Create an internal ……
[/Quote]