类似于循环记取的功能 DECLARE CursorJ CURSOR FOR -- 读取要填充指针的数据 SELECT Member_Code FROM tb_Day_Bonus WHERE StartDate = @p0 DECLARE @Member_Code nvarchar ( 1000 ) OPEN CursorJ FETCH NEXT FROM CursorJ INTO @Member_Code /**/ /*将指针的值赋给@Member_Code */ WHILE @@FETCH_STATUS = 0 BEGIN /**/ /*开始指针循环 */ -- 执行的代码 /**/ /* 下一循环 */ FETCH NEXT FROM CursorJ INTO @Member_Code END CLOSE CursorJ DEALLOCATE CursorJ