用SQL SERVER 2000的存储过程实现数据转成XML

CREATE proc usp_InsertXmlToTable
   @xmldoc ntext
as

set nocount on
Declare @hdoc int

begin
exec sp_xml_preparedocument @hdoc output,@xmldoc

--更新tb_sys_clan表
insert into tb_sys_clan
SELECT *
FROM   OPENXML (@hdoc, '/tables/table/row[../@tableName="tb_sys_clan"]',1)
       WITH (   Id     int             './Id/text()',
              ClanName  varchar(50)        './ClanName/text()'           
           )

exec sp_xml_removedocument @hdoc
end
GO