Function Parameter Properties
These read-only properties appear in the Properties window when you select a parameter for a function in Server Explorer.
Note
The properties in this topic are ordered by category rather than alphabet.
Note
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 Visual Studio Settings.
Identity Category
Expands to show the Name property.Name
Shows the name of the selected parameter.Misc Category
Expands to show properties such as Length, Precision, and Scale.Data Type
Shows the data type of the selected parameter.Note
For SQL Server, this property can take the value CURSOR if this is a stored procedures output parameter.
Length
Shows the maximum number of digits allowed for numeric data types. This property shows 0 for nonnumeric data types.Precision
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.Scale
Displays the maximum number of decimal digits that can appear to the right of the decimal point. This value must be less than or equal to the precision. This property shows 0 for nonnumeric data types.
See Also
Other Resources
Properties in Visual Database Tools