In SQL Server, a function that returns a single value is known as a “scalar UDF” or “scalar ... Consider this simple function: CREATE FUNCTION dbo.discount_price(@price DECIMAL(12,2), @ ...