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