CREATE PROCEDURE pro_MMTime_check
AS
declare @id int
declare @mmid int
declare @dt smalldatetime,@p_count int
declare @sendmessage_cur cursor
set @dt=getdate()
set @sendmessage_cur=cursor for select i_id,i_content from dbo.MMTask where d_sendTime <@dt and i_status=3
select @p_count=count(*) from dbo.MMTask where d_sendTime<@dt and i_status=3
if @p_count<>0
begin
open @sendmessage_cur
Fetch Next From @sendmessage_cur into @id,@mmid
while(@@FETCH_STATUS=0)
begin
---用户表里读取数据,发送 exec pro_sendMM_dy 'mmid'
update dbo.MMTask
set i_status=7 where i_id=@id
exec pro_sendMM_dy @id,@mmid
Fetch Next From @sendmessage_cur into @id,@mmid
end
close @sendmessage_cur
deallocate @sendmessage_cur
end
GO
AS
declare @id int
declare @mmid int
declare @dt smalldatetime,@p_count int
declare @sendmessage_cur cursor
set @dt=getdate()
set @sendmessage_cur=cursor for select i_id,i_content from dbo.MMTask where d_sendTime <@dt and i_status=3
select @p_count=count(*) from dbo.MMTask where d_sendTime<@dt and i_status=3
if @p_count<>0
begin
open @sendmessage_cur
Fetch Next From @sendmessage_cur into @id,@mmid
while(@@FETCH_STATUS=0)
begin
---用户表里读取数据,发送 exec pro_sendMM_dy 'mmid'
update dbo.MMTask
set i_status=7 where i_id=@id
exec pro_sendMM_dy @id,@mmid
Fetch Next From @sendmessage_cur into @id,@mmid
end
close @sendmessage_cur
deallocate @sendmessage_cur
end
GO