C. 对全局游标使用 SET
下例创建一个局部变量,然后将游标变量设置为全局游标名。DECLARE my_cursor CURSOR GLOBAL FOR SELECT * FROM authors
DECLARE @my_variable CURSOR
SET @my_variable = my_cursor
/* There is a GLOBAL declared
reference (my_cursor) and a LOCAL variable
reference (@my_variable) to the my_cursor
cursor. */
DEALLOCATE my_cursor /* There is now only a LOCAL variable
reference (@my_variable) to the my_cursor
cursor. */D. 使用 SET 定义游标
下例使用 SET 语句定义游标。DECLARE @CursorVar CURSORSET @CursorVar = CURSOR SCROLL DYNAMIC
FOR
SELECT LastName, FirstName
FROM Northwind.dbo.Employees
WHERE LastName like 'B%'OPEN @CursorVarFETCH NEXT FROM @CursorVar
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM @CursorVar
ENDCLOSE @CursorVar
DEALLOCATE @CursorVar
下例创建一个局部变量,然后将游标变量设置为全局游标名。DECLARE my_cursor CURSOR GLOBAL FOR SELECT * FROM authors
DECLARE @my_variable CURSOR
SET @my_variable = my_cursor
/* There is a GLOBAL declared
reference (my_cursor) and a LOCAL variable
reference (@my_variable) to the my_cursor
cursor. */
DEALLOCATE my_cursor /* There is now only a LOCAL variable
reference (@my_variable) to the my_cursor
cursor. */D. 使用 SET 定义游标
下例使用 SET 语句定义游标。DECLARE @CursorVar CURSORSET @CursorVar = CURSOR SCROLL DYNAMIC
FOR
SELECT LastName, FirstName
FROM Northwind.dbo.Employees
WHERE LastName like 'B%'OPEN @CursorVarFETCH NEXT FROM @CursorVar
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM @CursorVar
ENDCLOSE @CursorVar
DEALLOCATE @CursorVar
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货