FETCH NEXT FROM authors cursor Close authors cursor 关闭游标 运行结果如 238-95-7766 Carson Cheryl 415 548-7723 589 Darwin Ln. Berkeley CA 94705 1 表11-1SQL-92标准语法参数说明 例[11-2】建立一个只读游标。 declare cur authors cursor for select au Iname, au fname, phone, address, city, state from authors for read only 2. Transact SQL扩展定义 Transact SQL扩展定义游标语法格式为 DECLARE游标名 CURSOR [LOCAL GLOBAL [FORWARD ONLY SCROLL] [STATIC KEYSET DYNAMIC FAST FORWARD TREAD ONLY SCROLL LOCKS OPTIMISTIC ITYPE WARNING FOR Select语句 LFOR UPDATE [ OF column name L, 语法格式中参数简要说明如表11-2。FETCH NEXT FROM authors_cursor Close authors_cursor --关闭游标 运行结果如下： -------------------------------------------------------------------------------------------------------- --------- 238-95-7766 Carson Cheryl 415 548-7723 589 Darwin Ln. Berkeley CA 94705 1 表11-1 SQL-92标准语法参数说明 例[11-2】建立一个只读游标。 declare cur_authors cursor for select au_lname, au_fname, phone, address, city, state from authors for read only Transact_SQL扩展定义游标语法格式为： DECLARE游标名CURSOR [LOCAL | GLOBAL] [FORWARD_ONLY | SCROLL] [STATIC | KEYSET | DYNAMIC | FAST_FORWARD] [READ_ONLY | SCROLL_LOCKS | OPTIMISTIC] [TYPE_WARNING] FOR select_语句 [FOR UPDATE [OF column_name [,...n]]] 语法格式中参数简要说明如表11-2。 2．Transact_SQL扩展定义