cursordemo10.sql

来自「T-SQL示例大全」· SQL 代码 · 共 40 行

/* 文件名称: CursorDemo10.sql */
USE 北风贸易
GO

SET NOCOUNT ON

-- 声明一个局部的数据指针变量
DECLARE @MyCursor CURSOR

-- 使用 SET 命令定义局部数据指针变量的各项属性
SET @MyCursor = CURSOR LOCAL SCROLL FOR
    SELECT * FROM 客户

OPEN @MyCursor

FETCH NEXT FROM @MyCursor

WHILE @@FETCH_STATUS = 0
      FETCH NEXT FROM @MyCursor 

CLOSE @MyCursor
DEALLOCATE @MyCursor


--使用 SET 命令定义局部数据指针变量的各项属性
SET @MyCursor = CURSOR LOCAL SCROLL FOR
    SELECT * FROM 产品资料

OPEN @MyCursor

FETCH NEXT FROM @MyCursor

WHILE @@FETCH_STATUS = 0
      FETCH NEXT FROM @MyCursor 

CLOSE @MyCursor
DEALLOCATE @MyCursor