SQL SERVER 遊標的使用

標籤：style   blog   color   使用   os   for   div   ar   

--基於查詢聲明遊標declare cur CURSOR FORselect id from OrderProducts where OrderCode =@OrderCode    --select @OrderProductsId = id from OrderProducts where OrderCode [email protected]        --開啟遊標    OPEN cur    --讀取下一個遊標    FETCH NEXT FROM cur INTO @OrderProductsId        --遍曆遊標記錄，直至到達遊標的末尾    WHILE (@@FETCH_STATUS = 0)    BEGINIF @OrderProductsId <> ‘‘ or @OrderProductsId is not nullbegin   IF NOT EXISTS(SELECT 1 FROM OrderProducts WHERE IsInvented=0 AND id=@OrderProductsId) /*判斷訂單號是否是虛擬商品*/BEGINSET @error=-1080;GOTO FailedLabel;ENDend   FETCH NEXT FROM cur INTO @OrderProductsIdEND--關閉遊標CLOSE cur--釋放遊標DEALLOCATE cur