Functions | SQL 2005 Adventure Works OLTP |
Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
Syntax
dbo.ufnGetStock ( ProductID )
Parameters
Variable Data Type Required Description ProductID int Yes Input parameter for the scalar function ufnGetStock. Enter a valid ProductID from the Production.ProductInventory table.
Properties
Output data type Transactional Uses cursors Executes procedures Dynamic content Encrypted int No No No No No
Data Source Activity
Accesses Description Production.ProductInventory Product inventory information.
Applies to
Functions | Scalar