可以啊,你游标移动就可以了:
FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card
IF @@FETCH_STATUS = 0
begin
EXEC prc_sms_need_send_insert @varDate, @mobile, @varSms, 'XXXX', 'school', @varDate, 'IOD_MFXX',1FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card --加这句就行了
FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card
IF @@FETCH_STATUS = 0
begin
EXEC prc_sms_need_send_insert @varDate, @mobile, @varSms, 'XXXX', 'school', @varDate, 'IOD_MFXX',1FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card --加这句就行了
EXEC prc_sms_need_send_insert @varDate, @mobile, @varSms, 'XXXX', 'school', @varDate, 'IOD_MFXX',1FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card --加这句就行了
end --上面少了个end
指定 next
SELECT e.mobile, e.use_sms, f.beep_card
FROM student d JOIN stud_parent e ON d.userid = e.userid
LEFT JOIN timecard_beepcard f ON 1> 0 WHERE d.userid = @userid
DECLARE @mobile SYSNAME, @use_sms SYSNAME, @beep_card SYSNAME
OPEN sms_cursor
FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card
while @@FETCH_STATUS = 0
begin
EXEC prc_sms_need_send_insert @varDate,
@mobile, @varSms, 'XXXX', 'school', @varDate, 'IOD_MFXX',1
FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card
end
CLOSE sms_cursor
DEALLOCATE sms_cursor
DECLARE sms_cursor CURSOR SCROLL FOR SELECT e.mobile, e.use_sms, f.beep_card FROM student d JOIN stud_parent e ON d.userid = e.userid LEFT JOIN timecard_beepcard f ON 1> 0 WHERE d.userid = @userid
DECLARE @mobile SYSNAME, @use_sms SYSNAME, @beep_card SYSNAME
OPEN sms_cursor
begin
FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card
IF @@FETCH_STATUS = 0
EXEC prc_sms_need_send_insert @varDate, @mobile
FETCH NEXT FROM sms_cursor INTO @mobile, @use_sms, @beep_card
end
CLOSE sms_cursor
DEALLOCATE sms_cursor
DECLARE sms_cursor CURSOR SCROLL FOR
SELECT e.mobile, e.use_sms, f.beep_card
FROM student d JOIN stud_parent e ON d.userid = e.userid
LEFT JOIN timecard_beepcard f ON 1> 0 WHERE d.userid = @userid
DECLARE @mobile SYSNAME, @use_sms SYSNAME, @beep_card SYSNAME
OPEN sms_cursor
FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card
while @@FETCH_STATUS = 0
begin
EXEC prc_sms_need_send_insert @varDate,
@mobile, @varSms, 'XXXX', 'school', @varDate, 'IOD_MFXX',1
FETCH FIRST FROM sms_cursor INTO @mobile, @use_sms, @beep_card
end
CLOSE sms_cursor
DEALLOCATE sms_cursor