Returned Value Properties
These are the properties of valued returned by aggregate functions. To access them, open the Function node of your data source connection in Server Explorer, open the Aggregate Function node, open the node of the function, open the Parameters node, and click the return value for which you want information. If you do not see the nodes described, right-click the connection node of your data source, point to Change View, and click By Object Type.
Not
The properties in this topic are ordered by category rather than alphabet.
Not
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Working with Settings.
Identity Category
Expands to show the Name property.Name
Shows the name of the value.Misc Category
Expands to show the remaining properties.Data Type
Shows the data type of the selected value.Length
Shows the number of characters allowed for character-based data types.Precision
Shows the maximum number of digits allowed for numeric data types. This property shows 0 for nonnumeric data types.Scale
Shows the maximum number of digits that can appear to the right of the decimal point for numeric data types. This value must be less than or equal to the precision. This property shows 0 for nonnumeric data types.