declare @t table (id int) if(exists(select name from tempdb..sysobjects where name like'%test%' and type='u')) drop table #test create table #test(ids int ) insert into 192.168.1.10.数据库.表1(name,password) output inserted.id into @t sele
declare @t table (id int)
if(exists(select name from tempdb..sysobjects where name like'%test%' and type='u'))
   drop table #test
create table #test(ids int )
insert into 192.168.1.10.数据库.表1(name,password) output inserted.id into @t
select name ,password
from [user]
where not exists(select b.name from 192.168.1.10.数据库.表1 b where  name= b.name)
insert into  #test(ids) select id from @t
insert into insert into 192.168.1.10.数据库.表2(truename,userid)
select username,ids from #test
output不能远程 有没有别的办法 能获取到刚刚插入的所有的主键id  插入到 表2中