Dela via

  • Artikel

DataType.NumericScale Property

Gets or sets the numeric scale of the data type.

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

Syntax

'Declaration
Public Property NumericScale As Integer
    Get
    Set
'Usage
Dim instance As DataType
Dim value As Integer

value = instance.NumericScale

instance.NumericScale = value

public int NumericScale { get; set; }

public:
property int NumericScale {
    int get ();
    void set (int value);
}

member NumericScale : int with get, set

function get NumericScale () : int
function set NumericScale (value : int)

Property Value

Type: System.Int32
An Int32 value that specifies the numeric scale of the data type.

Examples

Visual Basic

Dim dt As DataType
dt = New DataType(SqlDataType.Decimal)
dt.NumericPrecision = 10

PowerShell

$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::Decimal)
$dt.NumericScale = 10