Table-valued functions, scalar-valued functions

Table-Valued Functions:
ALTER FUNCTION getTable ()
RETURNS TABLE as
RETURN (SELECT * from TB)
Value: SELECT * from GetTable ()
Scalar functions:
ALTER FUNCTION [dbo].   [Camonlineaverage] (
@projId INT,
@startDate DATETIME,
@endDate DATETIME
)
RETURNS Float as
Begin
DECLARE @result float,@s int,@t int;
SELECT @s=sum (Sumtime), @t=sum (TotalTime) from Dbo.tb_camonlinedetail (@projid, @startDate, @endDate)
IF (@t=0) begin RETURN 0.0 END
RETURN @s*100.0/@t
End

Value: Select Camonlineaverage (1212, ' 2016-5-5 ', ' 2016-8-8 ')

Table-valued functions, scalar-valued functions