SQL SERVER 可更新游标問題~~~`

[ggygd]

一個簡單的例子，想測試下，但好像不能更新email，不知道問題在哪裏？
declare my_cur CURSOR for select email from tbl_user
open my_cur
while @@fetch_status=0
begin
update tbl_user set email='test' where current of my_cur
fetch next from my_cur
end

[magicsnake]

语法上没有问题啊

[leohuang]

open my_cur
以下加上

fetch next from my_cur

[lizhizhe2000]

DECLARE My_Cur CURSOR SCROLL DYNAMIC
FOR
SELECT Email FROM MyUser
OPEN My_Cur
FETCH next FROM My_Cur
WHILE (@@FETCH_STATUS=0)
BEGIN
UPDATE MyUser SET Email='Just For Test' WHERE CURRENT OF My_Cur
FETCH next FROM My_Cur
END
DEALLOCATE My_Cur

[ggygd]

打开游标时,游标会自动地定位在记录集中的第一条记录上.

不用fetch next from my_cur

[leohuang]

事实胜于雄辩

你一试就知道了

[JavaK]

DECLARE My_Cur CURSOR SCROLL DYNAMIC
FOR
SELECT Email FROM MyUser
OPEN My_Cur
FETCH next FROM My_Cur
WHILE (@@FETCH_STATUS=0)
BEGIN
UPDATE MyUser SET Email='Just For Test' WHERE CURRENT OF My_Cur
FETCH next FROM My_Cur
END
DEALLOCATE My_Cur

[marsyyf]

可更新游标加上for update
declare my_cur CURSOR for select email from tbl_user for update

[ggygd]

UP

[kason_j]

很少使用CURSOR　
友情幫頂

[wypeng7115]

up