In SQL Server, a function that returns a single value is ... Consider this simple function: CREATE FUNCTION dbo.discount_price(@price DECIMAL(12,2), @discount DECIMAL(12,2)) RETURNS DECIMAL ...