output

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

-----------
         10

(1 rows affected)
1>