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 |
|
Helloise Smit
Starting Member
22 Posts |
 Posted - 2008-10-15 : 09:36:42
|
| when i write to my sql db i get the above. i i have a c# app that writes to a db.my table structure for the above fields are all numeric(8,6).how come i get THIS error?????i added to the precision but still not???can someone explain...thankshelloise |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-15 : 09:39:21
|
| because you're leaving only 2 digits (8-6) for value before decimal but have 3 digitscoming in value so make itnumeric(15,6) |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-15 : 09:41:50
|
DECIMAL(8, 6) means you can store any number that is at most 8 digits INCLUDING 6 digits for decimal part.That is -99.999999 to 99.999999420 is greater than 99.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-10-15 : 09:42:50
|
| with numeric(8,6) , you can have maximum value of 99.999999Try using numeric(12,2)MadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-10-15 : 09:43:26
|
double  MadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-15 : 09:43:48
|
quote:
Originally posted by madhivanan
double MadhivananFailing to plan is Planning to fail
Too slow Madhi  |
|
|
|
|
|
|
Still: parameter value '420.00000' out of range