| 服务器1;User ID=;Password=''''
).库1.dbo.表1 as g inner join OPENDATASOURCE(
''''SQLOLEDB'''',
''''Data Source=服务器1;User ID=;Password=''''
).库1.dbo.表1 as d on g.字段1=d.字段1
where g.字段2=0 and g.字段3=0 and s.字段4=6
open USR1
fetch next from USR into @GEN_ID,@FEE_STATUS_OPERATOR,@FEE_STATUS_OPERATETIME,@status_operateid,@client_sname
WHILE @@FETCH_STATUS = 0
BEGIN
insert into A(字段1，字段2。。。字段n)
values(@GEN_ID,''''2'''',''''0'''',@FEE_STATUS_OPERATOR,@FEE_STATUS_OPERATETIME,@status_operateid,@client_sname)
fetch next from USR1 into @GEN_ID,@FEE_STATUS_OPERATOR,@FEE_STATUS_OPERATETIME,@status_operateid,@client_sname
end
close USR1
deallocate USR1
----------------说明对于游标的利用可以多次，唯一的缺点的就是执行的时间过长！对于这方面要权衡考虑！
if (@@error<>0)
begin
rollback tran STATUS
end
else
begin
commit 上一页 [1] [2] [3] [4] 下一页 | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 