SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

DataType.NumericScale Property

SQL Server 2012

Gets or sets the numeric scale of the data type.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
public int NumericScale { get; set; }

Property Value

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

Visual Basic

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

PowerShell

Copy 
$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::Decimal)
$dt.NumericScale = 10
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.