一、带数据库连接的导入

insert into OPENDATASOURCE('SQLOLEDB','Data Source=222.35.*.*;User ID=***;Password=123456').yyedu.dbo.Article(ArticleID,CategoryID,CategoryName,Title,SubTitle,Author,Source,keyword,Description,

[Content],ClickCount,TimePublish,CreateDate,LastUpdateDate,CreateUserID,ID)

select newid() as id,'8243956A-4564-41DA-BC43-A48594B7F795' as categoryid,'本地新闻' as categoryname,

a.Title,a.Subheading,a.Author,a.CopyFrom,a.Keyword,a.Intro,a.Content,a.Hits,a.updatetime,

a.createtime,a.UpdateTime,a.Inputer,a.articleID

from dbo.PE_Article a inner join dbo.PE_Class b on a.classid=b.classid where b.classid='1' and a.status=3

 

二、不带数据库连接的导入

insert into dscms_edu.dbo.Article(ArticleID,CategoryID,CategoryName,Title,SubTitle,Author,Source,keyword,Description,

[Content],ClickCount,TimePublish,CreateDate,LastUpdateDate,CreateUserID,ID)

select newid() as id,'8243956A-4564-41DA-BC43-A48594B7F795' as categoryid,'本地新闻' as categoryname,

a.Title,a.Subheading,a.Author,a.CopyFrom,a.Keyword,a.Intro,a.Content,a.Hits,a.updatetime,

a.createtime,a.UpdateTime,a.Inputer,a.articleID

from dbo.PE_Article a inner join dbo.PE_Class b on a.classid=b.classid where b.classid='1' and a.status=3

本文来出自：