一个非常简单的问题

[zhaokeke2004]

我在一个存储过程中写了
declare @cursormdl cursor for sql_statment
时老是提示出错
去掉"@"就好了
难道不可以在存储过程中定义局部游标变量吗?为什么啊?

[shuiniu]

DECLARE @MyCursor CURSOR
------
???

[Rotaxe]

Transact-SQL 扩展语法
DECLARE cursor_name CURSOR
[ LOCAL | GLOBAL ]
[ FORWARD_ONLY | SCROLL ]
[ STATIC | KEYSET | DYNAMIC | FAST_FORWARD ]
[ READ_ONLY | SCROLL_LOCKS | OPTIMISTIC ]
[ TYPE_WARNING ]
FOR select_statement
[ FOR UPDATE [ OF column_name [ ,...n ] ] ]

cursor_name

是所定义的 Transact-SQL 服务器游标名称。cursor_name 必须遵从标识符规则。只能使用常数，要使用变量可以用动态SQL.

[zjcxc]

确实不能用变量.

[zjcxc]

如果要用变量,改用:

exec('declare '+@cursormdl|' cursor for sql_statment')

[shuiniu]

--创建
create procedure test
as
declare @test cursor
SET @test = CURSOR FOR
SELECT * FROM sysobjects
open @test
fetch next from @test
close @test
deallocate @test
go
--调用
exec test