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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-09-21 : 02:07:17
|
| When I try to insert a record to a money field in database it gives this error...what shouls be done to over come this errorServer: Msg 8152, Level 16, State 9, Line 3String or binary data would be truncated.The statement has been terminated. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-21 : 02:11:21
|
| data size you're trying to insert exceeds what was set for the field,compare your field type and size, and data size |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-09-21 : 02:18:38
|
| The field is money field and iam trying to insert 12 and 30 as values |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-21 : 02:33:06
|
| 12 and 30 are money data type as well? i think this is not the problem (i tried it and it worked), your record have other fields? have you checked them also?--editcan you provide your sql statement? |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-09-21 : 02:41:55
|
| Yes I got it thanks..there was one field which was char 1 and i was trying to insert values with 2 char...thanks a lot |
|
|
|
|
|
|
Conversion error