SQL SERVER 游标 更新

declare @order_no nvarchar(50)
declare @recordtime datetime


declare _cursor cursor for 
select order_no,recordtime from dbo.tb_alipay_logs where trade_status='TRADE_SUCCESS'
open _cursor
fetch next from _cursor into @order_no,@recordtime
while(@@fetch_status=0)
begin
update dbo.tb_Orders set MoneyReciveTime=@recordtime
where OrderNo=@order_no


fetch next from _cursor into @order_no,@recordtime
end
print @@fetch_status;
close _cursor

deallocate _cursor

注：从游标中取值时，参数的顺序一定要和游标中定义的顺序一致