.NET프로그래밍/SQL Server 2008

20. 제어문 - while문

holland14 2009. 9. 11. 13:46

-- 1부터100까지3의배수또는4의배수의합을구하는프로그램

 

--[1] Input

Declare @sum Int

Declare @i Int

Set @sum = 0

 

--[2] Process

Set @i = 1                                    --[1] 초기식

While @i <= 100

Begin

       if @i % 3 = 0 Or @i % 4 = 0            --[3] 조건식

       Begin

             Set @sum = @sum + @i             --[4] 실행문

       End

      

       Set @i = @i + 1                        --[2] 증감식

      

       if @i > 100                            --[!] 멈춤/계속

             Break

       Else

             Continue    

End

 

--[3] Output

Select @sum

print @sum