sql server中continue是什么意思,怎么用 ?
éæ°å¼å§ WHILE,for循ç¯é½å¯ä»¥çãå¨ CONTINUE å
³é®åä¹åçä»»ä½è¯å¥é½å°è¢«å¿½ç¥ãä¾å¦ï¼ä»¥ä¸æ±æ»20以å
è½è¢«2æ´é¤çæ´æ°ã循ç¯æ¶ï¼å¦æé£ä¸ªæ°ä¸è½è¢«2æ´é¤ï¼é£ä¹åé¢çä¸ç®¡è¯å¥å¤å°ï¼é½ä¸æ§è¡ï¼ç´æ¥è¿å
¥ä¸ä¸ä¸ªå¾ªç¯ãcontinue常ç¨æ¥å¤çï¼å
è¦æ»¡è¶³é¦è¦æ¡ä»¶ä¸ï¼åä½è¿ä¸æ¥å¤ççæ
åµ
declare @a int,
@i int,
@sum int
set @i=0
set @a=20
set @sum=0
while @i<@a
begin
set @i=@i+1
if @i % 2<>0
continue
else
begin
print @i
set @sum=@sum+@i
end
end
print @sum
ä¸è½æ¢è¡ï¼ä»ç»çç
declare @a int,
@i int,
@sum int
set @i=0
set @a=20
set @sum=0
while @i<@a
begin
set @i=@i+1
if @i % 2<>0
continue
else
begin
print @i
set @sum=@sum+@i
end
end
print @sum
ä¸è½æ¢è¡ï¼ä»ç»çç
温馨提示:答案为网友推荐,仅供参考