create proc test_temp as declare @callid varchar(15) DECLARE temp_ CURSOR FOR SELECT callid FROM mobile whERE flag = '1' ORDER BY callidOPEN temp_FETCH NEXT FROM temp_ INTO @callidWHILE @@FETCH_STATUS = 0 BEGIN Reply_User @callid
FETCH NEXT FROM temp_ INTO @callid ENDCLOSE temp_ DEALLOCATE temp_ GO
create proc test_temp as declare @callid varchar(15) DECLARE temp_ CURSOR FOR SELECT callid FROM mobile whERE flag = '1' ORDER BY callidOPEN temp_FETCH NEXT FROM temp_ INTO @callidWHILE @@FETCH_STATUS = 0 BEGIN exec Reply_User @callid
FETCH NEXT FROM temp_ INTO @callid ENDCLOSE temp_ DEALLOCATE temp_ GO
---------------------------
有啊 ,游标就象这样的。
二楼的说得有道理,输入参数要增加一个
存储过程中的控制过程要变化一下
as
declare @callid varchar(15)
DECLARE temp_ CURSOR FOR
SELECT callid FROM mobile whERE flag = '1' ORDER BY callidOPEN temp_FETCH NEXT FROM temp_ INTO @callidWHILE @@FETCH_STATUS = 0
BEGIN
Reply_User @callid
FETCH NEXT FROM temp_ INTO @callid
ENDCLOSE temp_
DEALLOCATE temp_
GO
as
declare @callid varchar(15)
DECLARE temp_ CURSOR FOR
SELECT callid FROM mobile whERE flag = '1' ORDER BY callidOPEN temp_FETCH NEXT FROM temp_ INTO @callidWHILE @@FETCH_STATUS = 0
BEGIN
exec Reply_User @callid
FETCH NEXT FROM temp_ INTO @callid
ENDCLOSE temp_
DEALLOCATE temp_
GO