Databases > AdventureWorks2019 > Scalar Functions > ufnGetProductStandardCost

AdventureWorks2019

ufnGetProductStandardCost

//

Scalar function returning the standard cost for a given product on a particular order date.

Created: 5/8/2023 Modified: 5/8/2023

Parameters

//

Scalar function returning the standard cost for a given product on a particular order date.

returns

[money] NULL
//

Input parameter for the scalar function ufnGetProductStandardCost. Enter a valid ProductID from the Production.Product table.

@ProductID

[int] NULL
//

Input parameter for the scalar function ufnGetProductStandardCost. Enter a valid order date.

@OrderDate

[datetime] NULL

Definition