The SMALLINT data type is used to represent a small integer type. The value range is available is from -32,768 to +32,767.
If a real number is entered for an SMALLINT type, the number is rounded to zero decimal place and the integer value is stored.
If you specify 8934 as SMALLINT, 8934 is stored.
If you specify 34.5 as SMALLINT, 35 is stored (all digits after the decimal point are rounded).
If you specify 23467 as SMALLINT, 23467 is stored.
If you specify 89354 as SMALLINT, an error occurs (if the allowable limit is exceeded).