用sqlserver过程把xml文件导入数据库

create proc?? p_mod_mxl???
@xml???? Ntext?? --注意：如果不用Ntext或nvarchar类型，xml内容里有中文会报错。
as??
DECLARE?? @idoc?? int??
EXEC?? sp_xml_preparedocument?? @idoc?? OUTPUT,?? @xml??
???
SELECT?? *????
FROM?? OPENXML?? (@idoc,?? '/STD002/row',?? 1)????
????????????? WITH?? (????????
????????????????????????? id???? ntext?? 'NewsID/.',
????????????????????????? title ntext?? 'NewsTitle/.',
??????? content ntext 'NewsContent/.')??
???
EXEC?? sp_xml_removedocument?? @idoc??
/*??
--调用存储过程??
exec?? p_mod_mxl '??
??? <STD002>????
????? <row>????????
????????????? <NewsID>1 </NewsID>
????????????? <NewsTitle>li</NewsTitle>
????????????? <NewsContent>content1</NewsContent>
????? </row>

????? <row>????????
????????????? <NewsID>2 </NewsID>
????????????? <NewsTitle>wang</NewsTitle>
????????????? <NewsContent>content2</NewsContent>
????? </row>
?????
</STD002>
'
*/
go??

?

参考：

http://hi.baidu.com/lichangzai/item/e74b3b0ebfb8fdf2a010340d

http://hi.baidu.com/lichangzai/item/33bd1837cc0f0198b80c030f

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!