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