Size in the SqlParameter

The size in SqlParameter has an effect on the data type parameters in a database that requires a specified size, such as nvarchar, if no size is specified for these types, the size that should be specified is deduced by default based on the assigned value, For data type types that have fixed size, they do not affect "such as int"

SqlParameter para=New SqlParameter ("@name", SqlDbType.Int,3);

The results of the monitoring are as follows:

SqlParameter para=New SqlParameter ("@name", sqldbtype.nvarchar,1);

The results of the monitoring are as follows:

SqlParameter para=New SqlParameter ("@name", sqldbtype.nvarchar,3);

The results of the monitoring are as follows:

SqlParameter para=New SqlParameter ("@name", SqlDbType.NVarChar);

The results of the monitoring are as follows:

Size in the SqlParameter