Dataset: ProductSubcategories

CollapseAll image

Collapse image Dataset properties


 Property   Value 
 Data source name   AdventureWorks 
 Referenced data set    
 Command type   Query 

Collapse image Parameters


Name 
@ProductCategory
Total: 1 parameter(s)

Collapse image Fields


Name  Source column  Data type  Caption  Value  Is calculated field 
ProductSubcategoryID ProductSubcategoryID System.Int16      
ProductCategoryID ProductCategoryID System.Int32      
Name Name System.String      
Total: 3 field(s)

Collapse image Filters


No filters exist

Collapse image Query


SELECT      ProductSubcategoryID, ProductCategoryID, Name
FROM        Production.ProductSubcategory
WHERE       (ProductCategoryID = @ProductCategory)

Collapse image See also


About this documentation