Difference between numerical and decimal datatypes

Difference between numerical and decimal datatypes

Decimal and numeric variables are functionally correspondent and accumulate numbers of set accuracy and scale.

Numeric type:

Positive numbers, negative numbers, whole numbers, decimals and fractional numbers from the numeric data.

Another  point to remember is numeric data only consists of numbers.

Decimal type:

Decimal data comprise of data to represent up to the smallest significant digit. In SQL server, decimal data comprises of both decimal and numeric data types. Both numeric and decimal data types are considered equivalent in SQL.

Byte representation of a decimal or numeric data is dependent on the total digits involved including ones after the decimal.