復制代碼 代碼如下:

CREATE TABLE [dbo].[xmlTable](
[id] [int] IDENTITY(1,1) NOT NULL,
[doc] [xml] NULL
)

復制代碼 代碼如下:

<?xml version='1.0' encoding='utf-8' ?>
<dd>
<a>dafaf2</a>
<a>dafaf3</a>
<a>dafaf4</a>
</dd>

復制代碼 代碼如下:

insert into xmlTable(doc)
select * from
openrowset(BULK 'C:/Documents and Settings/Administrator/桌面/1.xml',SINGLE_CLOB) as x