 |
Purpose
Returns the maximum number of digits to the right of the decimal point for the column.
This attribute is read only at runtime.
Data type |
Notes on the value returned |
approximate floating point number columns or parameters |
The scale is undefined, because the number of digits to the right of the decimal point is not fixed. |
datetime or interval data that contains a seconds component |
The decimal digits are defined as the number of digits to the right of the decimal point in the seconds component of the data. |
SQL_DECIMAL and SQL_NUMERIC |
The maximum scale is generally the same as the maximum precision, although some data sources impose a separate limit on the maximum scale. |
Syntax
Table.Column (ColumnID).Scale
|  |