两库操作

来源:互联网 发布:核子可乐 淘宝 编辑:程序博客网 时间:2024/05/19 08:02

insert into a
select  *  from [test2].dbo.a


update a  set name=b.name,value=b.value
 from (select * from [test2].dbo.a ) as b inner join
 a  a1 on a1.id=b.id