DECLARE @V_ACCOUNT VARCHAR (50);
DECLARE @V_NAME VARCHAR (50);
DECLARE
insert_logined_user_url_sort_cur CURSOR SCROLL FOR
SELECT user_id FROM account WHERE visit_count >= 1OPEN insert_logined_user_url_sort_cur
FETCH FIRST FROM insert_logined_user_url_sort_cur
INTO @V_ACCOUNTWHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @V_SHOW_INDEX_TEMP INT;
DECLARE @V_QID_TEMP INT;
SET @V_SHOW_INDEX_TEMP=5;
DECLARE
insert_logined_user_url_sort_inner1_cur CURSOR SCROLL FOR
SELECT u.name
FROM quick_enter q left join url_enter u on u.id=q.id
WHERE q.account = @V_ACCOUNT
OPEN insert_logined_user_url_sort_inner1_cur
FETCH FIRST FROM insert_logined_user_url_sort_inner1_cur
INTO @V_NAME WHILE @@FETCH_STATUS = 0
BEGIN
IF (@V_NAME != 'xx' or @V_NAME !='yy') BEGIN
SELECT @V_QID_TEMP = MAX(id) FROM quick_enter
INSERT INTO quick_enter VALUES(@V_QID_TEMP+1,@V_ACCOUNT,1,@V_SHOW_INDEX_TEMP)
INSERT INTO url_enter VALUES(@V_QID_TEMP+1,'ee','/eform/officialdoc/fillPetitionEForm.html')
SET @V_SHOW_INDEX_TEMP = @V_SHOW_INDEX_TEMP + 1;
INSERT INTO quick_enter VALUES(@V_QID_TEMP+2,@V_ACCOUNT,1,@V_SHOW_INDEX_TEMP)
INSERT INTO url_enter VALUES(@V_QID_TEMP+2,'ff','/eform/officialdoc/fillLetterEForm.html')
SET @V_SHOW_INDEX_TEMP = @V_SHOW_INDEX_TEMP + 1;
END FETCH NEXT FROM insert_logined_user_url_sort_inner1_cur
INTO @V_NAME
END CLOSE insert_logined_user_url_sort_inner1_cur
DEALLOCATE insert_logined_user_url_sort_inner1_cur FETCH NEXT FROM insert_logined_user_url_sort_cur
INTO @V_ACCOUNT
ENDCLOSE insert_logined_user_url_sort_cur
DEALLOCATE insert_logined_user_url_sort_cur
为什么执行到第二个WHILE @@FETCH_STATUS = 0 这就不执行了呢?
DECLARE @V_NAME VARCHAR (50);
DECLARE
insert_logined_user_url_sort_cur CURSOR SCROLL FOR
SELECT user_id FROM account WHERE visit_count >= 1OPEN insert_logined_user_url_sort_cur
FETCH FIRST FROM insert_logined_user_url_sort_cur
INTO @V_ACCOUNTWHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @V_SHOW_INDEX_TEMP INT;
DECLARE @V_QID_TEMP INT;
SET @V_SHOW_INDEX_TEMP=5;
DECLARE
insert_logined_user_url_sort_inner1_cur CURSOR SCROLL FOR
SELECT u.name
FROM quick_enter q left join url_enter u on u.id=q.id
WHERE q.account = @V_ACCOUNT
OPEN insert_logined_user_url_sort_inner1_cur
FETCH FIRST FROM insert_logined_user_url_sort_inner1_cur
INTO @V_NAME WHILE @@FETCH_STATUS = 0
BEGIN
IF (@V_NAME != 'xx' or @V_NAME !='yy') BEGIN
SELECT @V_QID_TEMP = MAX(id) FROM quick_enter
INSERT INTO quick_enter VALUES(@V_QID_TEMP+1,@V_ACCOUNT,1,@V_SHOW_INDEX_TEMP)
INSERT INTO url_enter VALUES(@V_QID_TEMP+1,'ee','/eform/officialdoc/fillPetitionEForm.html')
SET @V_SHOW_INDEX_TEMP = @V_SHOW_INDEX_TEMP + 1;
INSERT INTO quick_enter VALUES(@V_QID_TEMP+2,@V_ACCOUNT,1,@V_SHOW_INDEX_TEMP)
INSERT INTO url_enter VALUES(@V_QID_TEMP+2,'ff','/eform/officialdoc/fillLetterEForm.html')
SET @V_SHOW_INDEX_TEMP = @V_SHOW_INDEX_TEMP + 1;
END FETCH NEXT FROM insert_logined_user_url_sort_inner1_cur
INTO @V_NAME
END CLOSE insert_logined_user_url_sort_inner1_cur
DEALLOCATE insert_logined_user_url_sort_inner1_cur FETCH NEXT FROM insert_logined_user_url_sort_cur
INTO @V_ACCOUNT
ENDCLOSE insert_logined_user_url_sort_cur
DEALLOCATE insert_logined_user_url_sort_cur
为什么执行到第二个WHILE @@FETCH_STATUS = 0 这就不执行了呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货