SalesByCategory

Parameters

Parameter name Ordinal Native type Length Precision Scale Direction Is result-set
@CategoryName 1 nvarchar 15 0 0 Input
@OrdYear 2 nvarchar 4 0 0 Input

Model elements mapped on this stored procedure

Model Element Element type
SalesByCategory Stored Procedure Call

Result sets

Resultset1

Fields

Field name Ordinal Native type Length Precision Scale Is Nullable
ProductName 1 nvarchar 40 0 0
TotalPurchase 2 decimal 0 38 2 Yes
Model elements mapped on this resultset

None.