Home >Database >Mysql Tutorial >sqlserver批量插入
sqlserver批量插入
- WBOYOriginal
- 2016-06-07 15:39:411409browse
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中