MMSQL游标的使用

关注

原创最新推荐文章于 2026-09-16 13:43:06 发布 922 阅读 AI 写同款· GEO 优化 ›

Springboot+sqlserver+Quartz整合报错: Failure obtaining db row lock: 第 1 行: 只有 DECLARE CURSOR 才允许使用 FOR U 1.报错信息 org.springframework.context.ApplicationContextException: Failed to start bean 'quartzScheduler'; nested exception is org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler; nested exception is org.quartz.SchedulerConfig 阅读详情

--创建游标
declare DataPoint cursor
--读取部门表下级编号的数据
for select b_PriorID_i,b_Name_c,b_StaffOfDep from b_Hand where b_PriorID_i>@ID
--打开游标
open DataPoint

--读取值到
fetch next from DataPoint into @PriorID,@GetName,@HandName

while @@FETCH_STATUS=0
begin
--set @sql= N'select @BuMenNames=b_StaffOfDep,@PeopleNames=b_Name_c from b_Hand where b_PriorID_i='+CAST(@PriorID AS varchar(10))
--exec sp_executesql @sql,N'@BuMenNames varchar(50) out,@PeopleNames varchar(50) out',@HandName out,@GetName out
--将数据封装到临时表里面
insert into #HandInfo values(@PriorID,@GetName,@HandName)
--读取下一行值
fetch next from DataPoint into @PriorID,@GetName,@HandName
end
--关闭游标
close DataPoint
--释放对象
deallocate DataPoint

select * from #HandInfo

收录于