SQL SERVER updatable cursor problem ~~~ `

wq1e2wq3

A simple example, I want to test it, but I can't seem to update the email. I don't know what the problem is?
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

There is no problem in grammar

pronice

open my_cur
Add the following

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

When the cursor is opened, the cursor is automatically positioned on the first record in the record set.

Without fetch next from my_cur

pronice

Facts speak louder than words

You know it as soon as you try

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

Updatable cursor plus for update
declare my_cur CURSOR for select email from tbl_user for update