存储过程之游标

海粟1

于 2014-08-06 13:55:46 发布

阅读量616

点赞数

分类专栏：数据库学习

本文链接：https://blog.youkuaiyun.com/ZHENZHEN603282533/article/details/38400115

版权

数据库学习专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一个使用SQL游标的示例，展示了如何声明并操作游标以逐条处理查询结果，并通过动态SQL执行插入操作。此过程涉及变量赋值、条件判断等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

declare cur02 cursor local static scroll for
select gend_option,gend_name
from gend_det
where gend_gen = @ipq_part_3
and (rtrim(gend_char1) = '' or (charindex(rtrim(@ipq_cx) + ',', rtrim(gend_char1) + ',')) > 0)

open cur02
fetch first from cur02 into @tmp_option,@tmp_name
while @@fetch_status = 0
begin
select @ipq_line = @ipq_line + 10

select @sql='insert into #rst(r_part,r_option,r_require,r_rmks) (select '''+rtrim(@ipq_part)+''','''+rtrim(@tmp_option)+''',a'+rtrim(@tmp_option)+'a, r+'' ''+x+str(y) from t_ipqc$ where l='''+rtrim(@ipq_part)+''')'

exec(@sql)


select @temp_require = r_require from #rst where r_part=@ipq_part and r_option=@tmp_option

select @temp_rmks = r_rmks from #rst where r_part=@ipq_part and r_option=@tmp_option

insert into ipqd_det (ipqd_nbr,ipqd_line,ipqd_method,ipqd_project,ipqd_rst1,ipqd_rmks)
values(@ipq_nbr,@ipq_line,@tmp_name,'',isnull(@temp_require,''),isnull(@temp_rmks,''))


fetch next from cur02 into @tmp_option,@tmp_name
end

close cur02
deallocate cur02