select id from table1 for update 我刚才试了一下,不行。 set @i=0 我也试了,也是不行。
declare @i int, @UID varchar(12) set @i = 0 --赋给@i一个初始值 Declare csrRst Cursor SCROLL for SELECT ID FROM table1 OPEN csrRst FETCH NEXT FROM csrRst INTO @UID
WHILE (@@FETCH_STATUS = 0 ) BEGIN update TABLE1 SET id=CAST(@i AS VARCHAR(12)) WHERE CURRENT OF csrRst set @i=@i+1 FETCH NEXT FROM csrRst into @UID END CLOSE csrRst DEALLOCATE csrRst
to--nboys() 你的方法我试过了,不行,还是提示“游标是 READ ONLY 的”.
试一下这一个 declare @i int, @UID varchar(12) set @i = 0 Declare csrRst Cursor for SELECT ID FROM table1 OPEN csrRst FETCH NEXT FROM csrRst INTO @UID
WHILE (@@FETCH_STATUS = 0 ) BEGIN update TABLE1 SET id=CAST(@i AS VARCHAR(12)) WHERE CURRENT OF csrRst set @i=@i+1 FETCH NEXT FROM csrRst into @UID END CLOSE csrRst DEALLOCATE csrRst
declare @i int, @UID varchar(12) set @i = 0 Declare csrRst Cursor for SELECT ID FROM table1 OPEN csrRst FETCH NEXT FROM csrRst INTO @UID
WHILE (@@FETCH_STATUS = 0 ) BEGIN update TABLE1 SET id=CAST(@i AS VARCHAR(12)) WHERE ID=@UID set @i=@i+1 FETCH NEXT FROM csrRst into @UID END CLOSE csrRst DEALLOCATE csrRst
to zclxyh(常来) 现谢zclxyh(常来) 可以用了,能帮助解释一下吗? 只是去掉了"SCROLL",scroll,是不是指由标移动的方式,并没有指明游标是否可读。多谢高手指教!!
我刚才试了一下,不行。
set @i=0 我也试了,也是不行。
@i int,
@UID varchar(12)
set @i = 0 --赋给@i一个初始值
Declare csrRst Cursor SCROLL for
SELECT ID FROM table1
OPEN csrRst
FETCH NEXT FROM csrRst INTO @UID
WHILE (@@FETCH_STATUS = 0 )
BEGIN
update TABLE1 SET id=CAST(@i AS VARCHAR(12)) WHERE CURRENT OF csrRst
set @i=@i+1
FETCH NEXT FROM csrRst into @UID
END
CLOSE csrRst
DEALLOCATE csrRst
你的方法我试过了,不行,还是提示“游标是 READ ONLY 的”.
declare
@i int,
@UID varchar(12)
set @i = 0
Declare csrRst Cursor for
SELECT ID FROM table1
OPEN csrRst
FETCH NEXT FROM csrRst INTO @UID
WHILE (@@FETCH_STATUS = 0 )
BEGIN
update TABLE1 SET id=CAST(@i AS VARCHAR(12)) WHERE CURRENT OF csrRst
set @i=@i+1
FETCH NEXT FROM csrRst into @UID
END
CLOSE csrRst
DEALLOCATE csrRst
@i int,
@UID varchar(12)
set @i = 0
Declare csrRst Cursor for
SELECT ID FROM table1
OPEN csrRst
FETCH NEXT FROM csrRst INTO @UID
WHILE (@@FETCH_STATUS = 0 )
BEGIN
update TABLE1 SET id=CAST(@i AS VARCHAR(12)) WHERE ID=@UID
set @i=@i+1
FETCH NEXT FROM csrRst into @UID
END
CLOSE csrRst
DEALLOCATE csrRst
现谢zclxyh(常来)
可以用了,能帮助解释一下吗? 只是去掉了"SCROLL",scroll,是不是指由标移动的方式,并没有指明游标是否可读。多谢高手指教!!