how to run scalar-valued function in sql server code example
Example 1: functions with parameters SQL
SET @OrderID = dbo.GetOrderID (default, default, default);
Example 2: functions with parameters SQL
EXEC @OrderID = dbo.GetOrderID
@OrderType = @OrderType,
@ServiceSpeed = @Qty,
@Qty = @ServiceSpeed;