Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fizzer666
Starting Member
6 Posts |
 Posted - 2006-07-06 : 09:07:37
|
| Hi,Just looking through BOL:decimal[ (p[ , s] )] and numeric[ (p[ , s] )] Fixed precision and scale numbers. When maximum precision is used, valid values are from - 10^38 +1 through 10^38 - 1. The SQL-92 synonyms for decimal are dec and dec(p, s). numeric is functionally equivalent to decimal.Although functionally equivalent is there a reason for the two types? Maybe Backwards compatibility or some strange reason? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
differences between Numeric and decimal