SQL Function Örnek #1

Create Function FN_KareTopla
(
    @S1 INT,
    @S2 INT
)
RETURNS INT
As
Begin
    Declare [USER=1476294]@temp[/USER] INT, @toplam INT = 0;
    If @S1 > @S2
    Begin
        Set [USER=1476294]@temp[/USER] = @S1;
        Set @S1=@S2;
        Set @S2=@temp;
    End

    While @S1<=@S2
    Begin
        If @S2 % 2 = 0
            Set @toplam += @S2*@S2;
        Set @S2-=1;
    End
    Return @toplam;
End
Go