SQL 循环执行存储过程-临时表会被删除问题修改方法

    -- 方法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;