System.Data.SqlClient Namespace SqlParameter Class
Sets or retrieves the maximum number of digits for the parameter value.
| Script |
SqlParameter.Precision [ = bytes ] |
The property is read/write with a default value of 0.
IDbDataParameter.Precision
The Precision property is only used for numeric and decimal input parameters.
The following example initializes an SqlParameter and sets some of its properties.
public void CreateSqlParameter ( ) {
SqlParameter myParam = new SqlParameter ( "@Specs", SqlDbType.Decimal );
myParam.Value = 3.1416;
myParam.Precision = 8;
myParam.Scale = 4;
}
Public Sub CreateSqlParameter ( )
Dim myParam As New SqlParameter ( "@Specs", SqlDbType.Decimal )
myParam.Value = 3.1416
myParam.Precision = 8
myParam.Scale = 4
End Sub |
| |
C# |
VB |
SqlParameter Members Scale Size
