【Vegas原创】不同服务器进行插入数据的方法
1. Security->Linked Servers 创建名为KM的链接服务器。
2.
use vegas
insert into user_list (login_name,dept,active)
select login_name,dept_code,active from km.adt.dbo.user_list where dept_code='DC00'
insert into user_list (login_name,dept,active)
select login_name,dept_code,active from km.adt.dbo.user_list where dept_code='DC00'
喜欢请赞赏一下啦^_^
![](https://images.cnblogs.com/cnblogs_com/amadeuslee/1997630/o_21070809243911.jpg)