23.MS_SQL 2008 - 사용자 정의 함수 [2]

--dbo.Even(100) : 1~100까지짝수합

--dbo.Even(1000) : 1~1000까지짝수합

Create Function dbo.Even1(@n int)

Returns Int

As

       Begin

             Declare @sum Int

                    set @sum = 0

             Declare @i Int

                    set @i = 1

             While @i <=@n

             Begin

                    if @i %2 = 0 --한줄에는Begin,End 생략

                    Begin

                           set @sum = @sum + @i

                    end

                    set @i = @i + 1

             end

             Return @sum

       end

Go

 

Select dbo.Even1(100)

Go

---

23CreateSystemMethod.sql