Difference between numerical and decimal datatypes

Asked By 20 points N/A Posted on -

Dear friends

I would like to know what are the difference between storage type of decimal data types and numerical data types?




Answered By 0 points N/A #108793

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.

Login/Register to Answer

Related Questions