2个回答
展开全部
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
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
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
用游标
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
|
广告 您可能关注的内容 |
