有关游标的问题！！！

[wallis]

当执行
declare a_cur scroll cursor
for
select col1 from tb1
open a_cur

服务器: 消息 16916，级别 16，状态 1，行 4
名为 'a_cur' 的游标不存在。

而只执行
declare a_cur scroll cursor
for
select col1 from tb1
时成功

而且我用
deallocate a_cur
也成功


请问是什么原因？

[txlicenhe]

-- =============================================
-- Declare a SCROLL cursor and use various FETCH options
-- =============================================
DECLARE <cursor_name, sysname, test_cursor> SCROLL CURSOR FOR
<select_statement, , SELECT * FROM pubs.dbo.authors>

OPEN <cursor_name, sysname, test_cursor>

-- Fetch the first row in the cursor.
FETCH FIRST FROM <cursor_name, sysname, test_cursor>

-- Fetch the last row in the cursor.
FETCH LAST FROM <cursor_name, sysname, test_cursor>

-- Fetch the row immediately prior to the current row in the cursor.
FETCH PRIOR FROM <cursor_name, sysname, test_cursor>

-- Fetch the row immediately after the current row in the cursor.
FETCH NEXT FROM <cursor_name, sysname, test_cursor>

-- Fetch the nth row in the cursor.
FETCH ABSOLUTE <row_number, int, 8> FROM <cursor_name, sysname, test_cursor>

-- Fetch the row that is n rows before or after the current row.
FETCH RELATIVE <-/+ row_number, int, -2> FROM <cursor_name, sysname, test_cursor>

CLOSE <cursor_name, sysname, test_cursor>
DEALLOCATE <cursor_name, sysname, test_cursor>
GO

[codeh]

怎么我电脑上试不会出现这种情况呢？我用的是SQL SERVER2000个人版

[zjcxc]

错误应该不是出现在下面的语句上,我的电脑上也没有错.:
declare a_cur scroll cursor
for
select col1 from tb1
open a_cur

[sdhdy]

SQL SERVER2000 下，没问题啊！

[zjcxc]

刚才去试了,sql7.0也没有问题.

楼主最好将全部语句贴出.

[pengdali]

你试试呢？

declare a_cur scroll cursor for select * from pubs..jobs
open a_cur

deallocate a_cur