Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the maximum number of digits 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
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property NumericPrecision As Integer
Get
Set
'Usage
Dim instance As UserDefinedDataType
Dim value As Integer
value = instance.NumericPrecision
instance.NumericPrecision = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public int NumericPrecision { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property int NumericPrecision {
int get ();
void set (int value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member NumericPrecision : int with get, set
function get NumericPrecision () : int
function set NumericPrecision (value : int)
Property Value
Type: System.Int32
A Byte value that specifies the numerical precision of the user-defined data type.
Remarks
Numerical precision specifies the number of digits in a number. For example, the number 123.45 has a numerical precision of 5.
The numerical precision cannot be set to a value greater than the MaxLength property value.
Examples
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace