语法:
insert into 目标数据库.dbo.目标表名(字段1...字段n)
select 段1...字段n from 源数据库.dbo.源表名
实例:
insert into xiercaifudb.dbo.Article (IsValid, CreateTime, UpdateTime, Title, Contents, IsHot, ArticleType, IsShow, Sort)
select IsValid, CreateTime, UpdateTime, Title, Contents, IsHot, ArticleType, IsShow, Sort from freecaifudb.dbo.Article WHERE (ArticleType = 10)