SQL SERVER两个数据库两张表数据数据导入语法

-- 语法  INSERT INTO news(要导入表的字段) SELECT （数据源的对应字段） FROM Article_News where 条件

INSERT INTO news(title,content) SELECT N_title,N_content FROM Article_News where N_id<3000

 

 

 

INSERT INTO [YLSZ_DB_GaoBin].[dbo].[Article_News](N_Title,N_Content,N_pic,N_aID,N_mID,N_addTime,N_author,N_from,N_hitCount)
SELECT notice.ntitle,notice.ncontent,notice.nImg,
adminTable.aid,92,notice.ndate,
notice.author,notice.source,notice.count
FROM [ylsz_databaseServer].[dbo].[notice] notice, [ylsz_databaseServer].[dbo].[adminTable] adminTable 
WHERE  notice.nadmin=adminTable.anickname and notice.ntitle IS NOT NULL and notice.ntype=128  and notice.nid>5620

128：原来

92：现在

 

 

select distinct ntype from [dbo].[notice] where nid>6094