Difference between numerical and decimal datatypes

Asked By herbert welling 20 points N/A Posted on - 04/07/2012

Dear friends

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

Thanks

 

 

• Status: Open
• Question Views: 1120
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Perl

Answered By Mark Amna 5 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.

About Mark Amna

Questions
0

Answers
90

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 04/26/2012
• Question Category: Perl