Generated using SQL Data Dictionary demo version.

Scalar Function dbo.ufnGetStock

Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.

Parameter Data Type Default
@ProductID int
Input parameter for the scalar function ufnGetStock. Enter a valid ProductID from the Production.ProductInventory table.


Data Type Nullable
int X