两数据库表之间迁移插入数据

insert into CZJT_DB.dbo.ta_Article (Title,[Channel],[Depaid],Content,Source,[FileGroup],[Author],[Rank],[IsImportNotice],CreateTime)
select Title,1046,1001,Content,Source,[FileGroup],[Author],[Rank],[IsImportNotice],CreateTime
from [czjiantou].[dbo].[Sun_Article] where Channel=1082

posted @ 2020-03-10 17:24  阿旭92312  阅读(299)  评论(0编辑  收藏  举报