EXECUTE sp_executesql 返回游标值传入变量

[bfly2000]

语句大概是这样的：

DECLARE @CursorString varchar(500)
DECLARE @CursorName varchar(50)
DECLARE @itemid int
SET @CursorName='item_cursor1'
SET @CursorString='FETCH NEXT FROM '+ @CursorName +' INTO @itemid'
EXECUTE sp_executesql @CursorString

@CursorName是定义的游标名称，这个名称是动态的，现在要把游标值传入@itemid变量
执行时数据库报错,提示：必须声明变量 '@itemid'。

[昵称被占用了]

Try:

DECLARE @CursorString Nvarchar(500) 
DECLARE @CursorName Nvarchar(50) 
DECLARE @itemid int 
SET @CursorName=N'item_cursor1' 
SET @CursorString=N'FETCH NEXT FROM '+ @CursorName +' INTO @itemid' 
EXECUTE sp_executesql @CursorString ,N'@itemid int output',@itemid output

• 打赏
• 举报

回复 赞