22,209
社区成员
发帖
与我相关
我的任务
分享
例:
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
opendatasource
use d2
go
insert into table2
select * from db1..MaimTable1
left join db1..CTable1 on ...