游标更新数据

 DECLARE @ID INT, @Address varchar(200)

select  ID, Address

OPEN authors_cursor

FETCH NEXT FROM authors_cursor
INTO  @ID, @Address

-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
 select @UserName=username from 用户表 where id=@id
 print '开始更新'+ @UserName +'的数据';
 update 用户表 set Address=@Address where userid=@userid;
 FETCH NEXT FROM authors_cursor
    INTO  @ID, @Address ;
END

CLOSE authors_cursor
DEALLOCATE authors_cursor