-- 创建编号
declare @id_project_task bigint
-- 创建游标
DECLARE product_task_list CURSOR local for
select id_project_task from dbo.project_task where id_projects = @id_projects ORDER BY id_projects
-- 打开游标
OPEN product_task_list
-- 遍历游标开始
FETCH NEXT FROM product_task_list INTO @id_project_task WHILE @@FETCH_STATUS = 0
BEGIN
-- 测试游标
select @id_project_task
-- 下一个
FETCH NEXT FROM product_task_list INTO @id_project_task
END
-- 关闭游标
CLOSE product_task_list
-- 释放游标
DEALLOCATE product_task_list
END
GO