).库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]  下一页