-- 方法1:游标 -- 声明变量 DECLARE @tbsid AS INT -- 声明游标 DECLARE C_Employees CURSOR FAST_FORWARD FOR --查询物业信息 --SELECT worktableID FROM #TestTb SELECT WorkTable_ID FROM dbo.WorkFlowRecord WHERE WorkTable_ID IN(SELECT worktableID FROM #TestTb) AND IsAudit=0 OPEN C_Employees; -- 取第一条记录 FETCH NEXT FROM C_Employees INTO @tbsid WHILE @@FETCH_STATUS=0 BEGIN -- 操作 EXEC dbo.mt_per_Per_AutoBypassSkip_tbl @checkID =@tbsid-- int -- 取下一条记录 FETCH NEXT FROM C_Employees INTO @tbsid END -- 关闭游标 CLOSE C_Employees; -- 释放游标 DEALLOCATE C_Employees;