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 |
|
malachi151
Posting Yak Master
152 Posts |
 Posted - 2011-12-21 : 12:41:51
|
| Can anyone point me to a script that would show the maximum (and minimum) values for any given numeric datatype, include all precisions and scales for decimal types? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
malachi151
Posting Yak Master
152 Posts |
Posted - 2011-12-21 : 14:51:42
|
| No, I meant something like showing the actual numbers instead something like: - 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308.I mean for decimal it would be something like:decimal(1,0) | 9 | -9decimal(2,0) | 99 | -99decimal(3,0) | 999 | -999etc., etc. but with all possible values for all numeric data types with all precisions and scales. |
 |
|
|
|
|
|
Maximum values for datatypes...