用xml数据更新数据库

communityserver中用的: <? xml version="1.0" standalone="yes" ?> < feeds >    < feed >        < FeedId > 3 </ FeedId >        < Author > DaFangGuanLiYuan </ Author >        < Title > ddd </ Title >        < Description > sdfsdf </ Description >        < Source  />        < GuidName > 01be32bd-5d38-4bdf-8664-dc27b09903a7:6430 </ GuidName >        < GuidIsPermaLink > 0 </ GuidIsPermaLink >        < Link > http://localhost/TravelWeb/ForumsTA/NO6430/thread.aspx </ Link >        < PubDate > 2007-06-27T09:48:20 </ PubDate >        < CommentsUrl > http://localhost/TravelWeb/ForumsTA/NO6430/thread.aspx </ CommentsUrl >        < Creator > DaFangGuanLiYuan </ Creator >        < CommentApiUrl  />        < CommentRssUrl > http://localhost/TravelWeb/ForumsTA/commentrss.aspx?SectionID=248 & PostID=6430 </ CommentRssUrl >< CommentCount > -1 </ CommentCount ></ feed >      < feed >      < FeedId > 3 </ FeedId >      < Author > DaFangGuanLiYuan </ Author >      < Title > dddddddddd </ Title >      < Description > ssssssssssss </ Description >      < Source  />      < GuidName > 01be32bd-5d38-4bdf-8664-dc27b09903a7:6426 </ GuidName >      < GuidIsPermaLink > 0 </ GuidIsPermaLink >      < Link > http://localhost/TravelWeb/ForumsTA/NO6426/thread.aspx </ Link >      < PubDate > 2007-06-27T09:12:46 </ PubDate >      < CommentsUrl > http://localhost/TravelWeb/ForumsTA/NO6426/thread.aspx </ CommentsUrl >      < Creator > DaFangGuanLiYuan </ Creator >      < CommentApiUrl  />      < CommentRssUrl > http://localhost/TravelWeb/ForumsTA/commentrss.aspx?SectionID=248 & PostID=6426 </ CommentRssUrl >      < CommentCount > -1 </ CommentCount >    </ feed >      < feed >      < FeedId > 3 </ FeedId >      < Author > DaFangGuanLiYuan </ Author >      < Title > ddd </ Title >      < Description > sdfsdfsdf </ Description >      < Source  />      < GuidName > 01be32bd-5d38-4bdf-8664-dc27b09903a7:6424 </ GuidName >      < GuidIsPermaLink > 0 </ GuidIsPermaLink >      < Link > http://localhost/TravelWeb/ForumsTA/NO6424/thread.aspx </ Link >      < PubDate > 2007-06-26T17:00:12 </ PubDate >      < CommentsUrl > http://localhost/TravelWeb/ForumsTA/NO6424/thread.aspx </ CommentsUrl >      < Creator > DaFangGuanLiYuan </ Creator >      < CommentApiUrl  />      < CommentRssUrl > http://localhost/TravelWeb/ForumsTA/commentrss.aspx?SectionID=248 & PostID=6424 </ CommentRssUrl >      < CommentCount > -1 </ CommentCount >    </ feed > </ feeds >    CREATE   PROC   [ dbo ] .cs_FeedPost_UpdatePosts    @FeedId   INT ,    @FeedItemList   NTEXT    AS      SET  NOCOUNT  ON      DECLARE   @idoc   INT    DECLARE   @FeedPosts   TABLE   (   FeedId  INT ,   Author  NVARCHAR ( 255 ),   Title  NVARCHAR ( 255 ),   Description  NTEXT ,   Source  NVARCHAR ( 255 ),   GuidName  NVARCHAR ( 255 ) collate database_default,   GuidIsPermaLink  BIT ,   Link  NVARCHAR ( 255 ),   PubDate  DATETIME ,   CommentsUrl  NVARCHAR ( 255 ),   EnclosureUrl  VARCHAR ( 255 ),   EnclosureLength  BIGINT ,   EnclosureType  NVARCHAR ( 100 ),   Creator  NVARCHAR ( 255 )  NULL ,   CommentApiUrl  NVARCHAR ( 255 )  NULL ,   CommentRssUrl  NVARCHAR ( 255 )  NULL ,   CommentCount  INT   NULL   )     EXEC  sp_xml_preparedocument  @idoc  OUTPUT,  @FeedItemList      --  First off, let's move all the XML into the table variable.   INSERT   INTO   @FeedPosts      SELECT  C.FeedId,   C.Author,   C.Title,   C.Description,   C.Source,   C.GuidName,   C.GuidIsPermaLink,   C.Link,   C.PubDate,   C.CommentsUrl,   C.EnclosureUrl,   C.EnclosureLength,   C.EnclosureType,   C.Creator,   C.CommentApiUrl,   C.CommentRssUrl,   C.CommentCount   FROM  OPENXML( @idoc ,  ' /feeds/feed ' ,  3 )     WITH  ( FeedId  INT ,   Author  NVARCHAR ( 255 ),   Title  NVARCHAR ( 255 ),   Description  NTEXT ,   Source  NVARCHAR ( 255 ),   GuidName  NVARCHAR ( 255 ),   GuidIsPermaLink  BIT ,   Link  NVARCHAR ( 255 ),   PubDate  DATETIME ,   CommentsUrl  NVARCHAR ( 255 ),   EnclosureUrl  VARCHAR ( 255 ),   EnclosureLength  BIGINT ,   EnclosureType  NVARCHAR ( 100 ),   Creator  NVARCHAR ( 255 ),   CommentApiUrl  NVARCHAR ( 255 ),   CommentRssUrl  NVARCHAR ( 255 ),   CommentCount  INT )  AS  C     --  Insert missing posts   INSERT   INTO  cs_FeedPost  (   FeedId,   Author,   Title,   Description,   Source,   GuidName,   GuidIsPermaLink,   Link,   PubDate,   CommentsUrl,   EnclosureUrl,   EnclosureLength,   EnclosureType,   Creator,   CommentApiUrl,   CommentRssUrl,   CommentCount     )   SELECT   C.FeedId,   C.Author,   C.Title,   C.Description,   C.Source,   C.GuidName,   C.GuidIsPermaLink,   C.Link,   C.PubDate,   C.CommentsUrl,   C.EnclosureUrl,   C.EnclosureLength,   C.EnclosureType,   C.Creator,   C.CommentApiUrl,   C.CommentRssUrl,   C.CommentCount   FROM   @FeedPosts   AS  C   WHERE  C.GuidName  NOT   IN   (     SELECT  GuidName  FROM  cs_FeedPost      WHERE  FeedId  =   @FeedId      )       --  Update existing posts.   UPDATE  cs_FeedPost   SET  Author  =  C.Author,   Title  =  C.Title,   Description  =  C.Description,   Source  =  C.Source,   GuidName  =  C.GuidName,   GuidIsPermaLink  =  C.GuidIsPermaLink,   Link  =  C.Link,   PubDate  =  C.PubDate,   CommentsUrl  =  C.CommentsUrl,   EnclosureUrl  =  C.EnclosureUrl,   EnclosureLength  =  C.EnclosureLength,   EnclosureType  =  C.EnclosureType,   Creator  =  C.Creator,   CommentApiUrl  =  C.CommentApiUrl,   CommentRssUrl  =  C.CommentRssUrl,   CommentCount  =  C.CommentCount   FROM   @FeedPosts   AS  C   WHERE  cs_FeedPost.GuidName  =  C.GuidName         EXEC  sp_xml_removedocument  @idoc         

转载于:https://www.cnblogs.com/Elong/archive/2007/07/04/805799.html

相关资源：基于XML异构数据库查询与更新系统研究