declare
@V_MRP_NO VARCHAR(100),
@V_MRP_NAME VARCHAR(100),
@V_SO_NO VARCHAR(60),
@V_XT_NO VARCHAR(60)
declare my_cur cursor for --定义游标
SELECT DISTINCT MRP_NO,MRP_NAME,SO_NO,XT_NO
FROM #TF_ML
open my_cur --打开游标
fetch next from my_cur into @V_MRP_NO,@V_MRP_NAME,@V_SO_NO,@V_XT_NO --读游标
while @@fetch_status=0
begin
--------这里处理业务逻辑
---------
fetch next from my_cur into @V_MRP_NO,@V_MRP_NAME,@V_SO_NO,@V_XT_NO --循环读游标
end
close my_cur --关闭释放游标
deallocate my_cur