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 |
|
outspaced
Starting Member
21 Posts |
 Posted - 2006-12-19 : 10:56:05
|
| This is a really silly question, but it's a really silly situation. I am completely baffled as to why this is happening.I have 2 tables. Both tables have a number of fields of the type decimal (9). When I do inserts, one of the tables inserts ok, but for some reason the other one rounds the numbers I am inserting to integers. This makes no sense to me at all, I've checked that the table is correct 1000 times (or close to that anyway).Does anyone have any ideas? I feel like I'm going mad.cheers,Alex |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-19 : 11:02:47
|
| Is it DECIMAL(9,0) versus DECIMAL(9,x) where x is a number between 1 and 8?Peter LarssonHelsingborg, Sweden |
 |
|
|
outspaced
Starting Member
21 Posts |
Posted - 2006-12-19 : 11:03:04
|
| Ah yes, that would be a problem with scale ... turns out I'm not mad, just not observant |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-19 : 11:06:11
|
Welcome to the club  Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Mysterious rounding