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.

Result:


Data Type Nullable
int X

Uses: