游标的使用简单例子:
CREATE PROC [WSP_PM_DeleteNode]
(
@SiteID INT, -- 站点标识
@NodeID INT -- 游戏标识
)
WITH ENCRYPTION AS
-- 属性设置
SET NOCOUNT ON
BEGIN
DECLARE @ChildNode INT
-- 定义游标.
DECLARE c_node CURSOR FAST_FORWARD FOR
SELECT NodeID FROM GameListNode WHERE JoinID=@NodeID AND SiteID=@SiteID
-- 打开游标
OPEN c_node;
WHILE 1=1
BEGIN
-- 填充数据.
FETCH NEXT FROM c_node INTO @ChildNode
-- 假如未检索到数据,退出循环.
IF @@fetch_status!= 0
BREAK;
PRINT @ChildNode
END
-- 关闭游标
CLOSE c_node;
-- 释放游标
DEALLOCATE c_node;
RETURN 0
END
GO