| ).库1.dbo.表1 as d on g.字段1=d.字段1 inner join OPENDATASOURCE(
''''SQLOLEDB'''',
''''Data Source=服务器1;User ID=;Password=''''
).库2.dbo.表1‘ as s on g.字段1=s.字段1 where g.字段2=0 and g.字段3=0 and s.字段4=6
open USR
fetch next from USR into @GEN_ID,@QUAN
WHILE @@FETCH_STATUS = 0
BEGIN
update 库A.dbo.表 set 字段=@QUAN where 字段1=rtrim(@GEN_ID)
fetch next from USR into @GEN_ID,@QUAN
end
close USR
deallocate USR
declare USR1 cursor for select 字段1，字段2，120，...字段n
from OPENDATASOURCE(
''''SQLOLEDB'''',
''''Data Source= 上一页 [1] [2] [3] [4] 下一页 | 
