在存储过程中怎么将查询出的多条记录赋值给变量

Question

可不可以给个例子

Answer 1

create proc upt_sp
as
begin
declare @name,...
declare mycur cursor for select name,... from table where ....
open mycur
fetch next from mycur into @name,...
begin
update table2 set name=@name,... where .....
fetch next from mycur into @name,...
end
close mycur
deallocate mycur
end

Answer 2

用游标