SQL CURSOR 同时选择多列值
2011-05-23 20:04 calm_水手 阅读(427) 评论(0) 编辑 收藏 举报
DECLARE @ofId int,@Amount decimal(18,2),@OrderID varchar(20)
DECLARE curOfId CURSOR FOR
SELECT lotOfId,lotWinMoney,t1.lotOrderID
FROM IP_OrderLottery AS t1 INNER JOIN View_OfficeInfo_CityCountry AS t2
ON t1.lotOfId=t2.ofId
WHERE t1.lotIsUpdateReward=0
OPEN curOfId
FETCH NEXT FROM curOfId INTO @ofId,@Amount,@OrderID
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @ofId
PRINT @Amount
PRINT @OrderID
FETCH NEXT FROM curOfId INTO @ofId,@Amount,@OrderID
END
CLOSE curOfId
DEALLOCATE curOfId
DECLARE curOfId CURSOR FOR
SELECT lotOfId,lotWinMoney,t1.lotOrderID
FROM IP_OrderLottery AS t1 INNER JOIN View_OfficeInfo_CityCountry AS t2
ON t1.lotOfId=t2.ofId
WHERE t1.lotIsUpdateReward=0
OPEN curOfId
FETCH NEXT FROM curOfId INTO @ofId,@Amount,@OrderID
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @ofId
PRINT @Amount
PRINT @OrderID
FETCH NEXT FROM curOfId INTO @ofId,@Amount,@OrderID
END
CLOSE curOfId
DEALLOCATE curOfId
