xml文档解析并把解析结果存入sql server数据库

DECLARE @idoc int,@doc varchar(8000)

--从文件中读出XML内容到临时表(F:\corpus samples\sen0001.xml)
create table #tb (doc varchar(8000))
bulk insert #tb from 'F:\corpus samples\sen0001.xml'

--将读取到的数据保存到变量中
set @doc=''
select @doc=@doc+doc from #tb

--删除临时表
drop table #tb

--获取数据
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

--创建测试的表
create table syllables
(ch_char char(4),pinyin char(10),start_sample int,end_sample int)

--下面是数据处理
insert into syllables(ch_char,pinyin,start_sample,end_sample)

SELECT * FROM OPENXML (@idoc, '/utterance/sentence/prosodic_phrase/prosodic_word/syllable',2)
WITH (ch_char char(4) '@ch_char',
pinyin char(10) '@pinyin',
start_sample int '../sil/@end_sample',
end_sample int '@end_sample')

EXEC sp_xml_removedocument @idoc

-