同步数据

  insert into MoneyNews
      (ObjectID,Creator,CreateDate,StyleID,Title,Author,summary,articlesource,Content,ContentType)
  select
   c.OB_OBJECT_ID         ObjectID,
        '数据'                        Creator,
   c.f004d_0021         CreateDate,
   '27'                               StyleID,
   c.f005v_0021                    Title,
   c.f001v_0021                Author,
   c.f007v_0021            summary,
   c.f003v_0021      articlesource,
   c.f006l_0021              Content,
   '创富历程'              ContentType
 
  from cmslinkcpdb.cpdb.dbo.tb_text_0031 as a,cmslinkcpdb.cpdb.dbo.tb_text_0022 as b,cmslinkcpdb.cpdb.dbo.tb_text_0021 as c
  where a.ob_sortcode_0031=b.ob_sortcode_0022