Databases
>
AdventureWorks2019
>
Scalar Functions
> ufnGetStock
AdventureWorks2019
ufnGetStock
//
Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
Created:
5/8/2023
Modified:
5/8/2023
Parameters
//
Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
returns
[int] NULL
//
Input parameter for the scalar function ufnGetStock. Enter a valid ProductID from the Production.ProductInventory table.
@ProductID
[int] NULL
Definition