遊標使用-迴圈語句

標籤：使用   os   for   ar   div   on   sp   res   

--模型Declare @MemberID int Declare csTemp Cursor For

Select MemberID From xxx Open csTemp Fetch Next From csTemp Into @MemberIDWhile @@fetch_status=0 Begin

xxx……

Fetch Next From csTemp Into @MemberID

End Close csTempDeallocate csTemp

 --舉例Declare @MemberID int,@BetCoin money,@AwardCoin money,@IsSystem bit --中獎會員，會員所投，當前獎勵金豆數量    Declare csTemp Cursor For    Select Distinct MemberID,BetCoin,IsSystem From XyDou_Game_Au11_Bet    Where WinCoin=0 and [email protected] and BetNumber= @result and ( IsSystem=0 or IsSystemGameGoldExchange=1 )   Open csTemp   Fetch Next From csTemp Into @MemberID,@BetCoin,@IsSystem   While @@fetch_status = 0 --如果遊標存在      Begin

    --處理語句.....

    Set @AwardCoin = Round(@BetCoin*@Pv,0,1)

   

    Exec P_Member_ChangeGold_Value ‘遊戲‘,@AwardCoin,@MemberID,1

      Fetch Next From csTemp Into @MemberID,@BetCoin,@IsSystem --跳到下個遊標   End        Close csTemp --關閉遊標   Deallocate csTemp --釋放遊標