資料庫表之間的資料匯入 sql語句

一、帶資料庫連接的匯入
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

本文來出自：寧鄉網站建設