DECLARE @ns varchar(100) DECLARE @c varchar(100) SET @c='2,3' SET @ns='SELECT * FROM RAMP_RBD_NODE WHERE ID_Code IN ('+@c+')' exec('DECLARE nd CURSOR FOR ' + @ns )
DECLARE @ns varchar(100) DECLARE @c varchar(100) SET @c='2,3' SET @ns='SELECT * FROM RAMP_RBD_NODE WHERE ID_Code IN ('+@c+')' exec('DECLARE nd CURSOR FOR ' + @ns )open ndfetch next from nd ...colse nd deallocate nd
可我接下来怎么使用nd呢?接下来像下面这样好象不行. DECLARE @nid int FETCH NEXT FROM nd INTO @nid 提示游标未打开。 多谢各位,希望问题能彻底解决
多谢各位。
DECLARE @c varchar(100)
SET @c='2,3'
SET @ns='SELECT * FROM RAMP_RBD_NODE WHERE ID_Code IN ('+@c+')'
exec('DECLARE nd CURSOR FOR ' + @ns )
DECLARE @c varchar(100)
SET @c='2,3'
SET @ns='SELECT * FROM RAMP_RBD_NODE WHERE ID_Code IN ('+@c+')'
exec('DECLARE nd CURSOR FOR ' + @ns )open ndfetch next from nd
...colse nd
deallocate nd
DECLARE @nid int
FETCH NEXT FROM nd INTO @nid
提示游标未打开。
多谢各位,希望问题能彻底解决