This topic has not yet been rated - Rate this topic

NumericScale Property

SQL Server 2005

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The NumericScale property specifies the number of digits to the right of the decimal point in a fixed-precision, numeric data type.

Syntax


object
.NumericScale [= value]

Parts

object: An expression that evaluates to an object in the Applies To list

value: A long integer value from 0 through the value of the NumericPrecision property of the Column or UserDefinedDatatype object

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetNumericScale(LPLONG pRetVal);
HRESULT SetNumericScale(long NewValue);

Applies To:

Column Object

UserDefinedDatatype Object

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD