Syntax:
CREATE FUNCTION [owner_name.]function_name ([{@parameter_name[AS] scalar_parameter_data_type[=default]}[,...n]])
RETURNS scalar_return_data_type
[WITH {ENCRYPTION|SCHEMABINDING}]
[AS]
BEGIN
function_body
RETURN scalar_expression
END
1.First,Create following scalar-valued function:
CREATE FUNCTION Year_Wage(@work_date DATETIME,@now_date DATETIME,@per_wage DECIMAL)
RETURNS DECIMAL
AS
BEGIN
RETURN ((YEAR(@now_date)-YEAR(@work_date))*@per_wage)
END
2.Call the above scalar-valued function:
SELECT dbo.Year_Wage ('1997-9-1',GETDATE(),12) AS 'total wage'