pr_GetProducts
Parameters
| Parameter name | Ordinal | Native type | Length | Precision | Scale | Direction | Is result-set |
|---|---|---|---|---|---|---|---|
| @discontinuedFlag | 1 | int | 0 | 10 | 0 | Input |
Model elements mapped on this stored procedure
| Model Element | Element type |
|---|---|
| GetProducts | Stored Procedure Call |
Result sets
Resultset1
Fields
| Field name | Ordinal | Native type | Length | Precision | Scale | Is Nullable |
|---|---|---|---|---|---|---|
| ProductID | 1 | int | 0 | 10 | 0 | |
| ProductName | 2 | nvarchar | 40 | 0 | 0 | |
| SupplierID | 3 | int | 0 | 10 | 0 | Yes |
| CategoryID | 4 | int | 0 | 10 | 0 | Yes |
| QuantityPerUnit | 5 | nvarchar | 20 | 0 | 0 | Yes |
| UnitPrice | 6 | money | 0 | 19 | 4 | Yes |
| UnitsInStock | 7 | smallint | 0 | 5 | 0 | Yes |
| UnitsOnOrder | 8 | smallint | 0 | 5 | 0 | Yes |
| ReorderLevel | 9 | smallint | 0 | 5 | 0 | Yes |
| Discontinued | 10 | bit | 0 | 0 | 0 | |
| PreferredProduct | 11 | bit | 0 | 0 | 0 | Yes |
Model elements mapped on this resultset
None.