Partilhar via


UserDefinedDataType.NumericScale Property

Gets or sets the maximum number of digits to the right of the decimal point in a numeric value used in the definition of the user-defined data type.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property NumericScale As Integer
public int NumericScale { get; set; }
public:
property int NumericScale {
    int get ();
    void set (int value);
}
/** @property */
public int get_NumericScale ()

/** @property */
public void set_NumericScale (int value)
public function get NumericScale () : int

public function set NumericScale (value : int)

Property Value

A Byte value that specifies the numerical scale of the user-defined data type.

Remarks

Numerical scale specifies the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a numerical scale of 2.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Construct a DataType Object by Using the Default Constructor in Visual Basic .NET

How to: Construct a DataType Object with the Specification in the Constructor in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

UserDefinedDataType Class
UserDefinedDataType Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Data Types (Database Engine)
CREATE TYPE (Transact-SQL)