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

wq1e2wq3

一個簡單的例子，想測試下，但好像不能更新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

shygza

语法上没有问题啊

pronice

open my_cur
以下加上

fetch next from my_cur

苹果小刀

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

wq1e2wq3

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

不用fetch next from my_cur

pronice

事实胜于雄辩

你一试就知道了

suncat10

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

hollymoon

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