本文介绍了一个SQL存储过程示例，该过程通过游标遍历指定状态的记录，并更新这些记录中的字段。此示例展示了如何声明并使用游标、执行更新操作以及处理流程控制。
alter proc demo_proc
as
begin
declare updateCursor cursor for
select jhlsh from jgpj_khjh_jbxx where qyzt='1' and qsyf is not null
open updateCursor
declare @jhlsh varchar(64)
fetch next from updateCursor into @jhlsh
while @@FETCH_STATUS=0
begin
print @jhlsh
update jgpj_khjh_jbxx set JHMC=REPLACE(JHMC,'计划','plan') where JHLSH=@jhlsh
fetch next from updatecursor into @jhlsh
end
close updatecursor
deallocate updatecursor
end
as
begin
declare updateCursor cursor for
select jhlsh from jgpj_khjh_jbxx where qyzt='1' and qsyf is not null
open updateCursor
declare @jhlsh varchar(64)
fetch next from updateCursor into @jhlsh
while @@FETCH_STATUS=0
begin
print @jhlsh
update jgpj_khjh_jbxx set JHMC=REPLACE(JHMC,'计划','plan') where JHLSH=@jhlsh
fetch next from updatecursor into @jhlsh
end
close updatecursor
deallocate updatecursor
end
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
