output2

1> CREATE FUNCTION dbo.TestFunction2 (@Int INT)
2> RETURNS INT
3> AS
4> BEGIN
5> WHILE @Int < 10
6> BEGIN
7> SET @Int = @Int + 2
8> END
9> RETURN @Int
10> END
11> GO
1> SELECT dbo.TestFunction2(5)
2> GO

-----------
         11

(1 rows affected)