sqlserver 导入部份列
发布网友
共1个回答
热心网友
一、在服务器B上给A1增加2个字段
alter table A1 add f int
alter table A1 add g int
二、在服务器B上执行如下sql脚本
update A1
set f = AA1.f, g = AA1.g
FROM A1 as BA1, OPENROWSET('SQLOLEDB','服务器A的ip地址';'sa';'password',
'select id,f,g from A1) AS AA1
where BA!.id = AA1.id
