写个存储过程,将你的参数传到过程里面,具体操作都在过程里面执行. create proc InsertData @id int @name varchar(20) @item varchar(20) as insert into 数据库2.dbo.table2 select id,name,item from MainTable1 join CTable1 on ...... where id=@id and name=@name and item=@item
例: insert into Dic_C2ndCategory(c1id,c2name,c2define) select '2000024',prdname,prdclass from opendatasource('sqloledb', 'server=192.168.254.99; User ID=sa;Password=sa' ).NG0001.dbo.prdclass a where len(a.prdclass)=2
insert into table2 select d1.dbo.table1 where....
本机的直接使用
use d2
go
insert into table2
select * from db1..MaimTable1
left join db1..CTable1 on ...
写个存储过程,将你的参数传到过程里面,具体操作都在过程里面执行.
create proc InsertData
@id int
@name varchar(20)
@item varchar(20)
as
insert into 数据库2.dbo.table2
select id,name,item from MainTable1 join CTable1 on ......
where id=@id and name=@name and item=@item
==============
insert select 用这个,确保字段都一样
insert into Dic_C2ndCategory(c1id,c2name,c2define)
select '2000024',prdname,prdclass from opendatasource('sqloledb', 'server=192.168.254.99;
User ID=sa;Password=sa'
).NG0001.dbo.prdclass a
where len(a.prdclass)=2