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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-04-07 : 11:01:59
|
| I need to run this update statement in QA. When I have the where clause, It run fine. When I tried to run it without the where clause for the rest of data set, I got this message.UPDATE usersalesrep SET usersalesrep.USER1 = aaa.user1from aaa join useridmaster um on aaa.firstname=um.lastname and aaa.lastname=um.firstname join usersalesrep on usersalesrep.userid=um.useridwhere um.lastname='bayne'Server: Msg 8152, Level 16, State 2, Line 1String or binary data would be truncated.The statement has been terminated.I could not find any column or data invloved here has binary type or long string.I dont know what else to check. Thanks for nay help! |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-07 : 11:04:20
|
| It means that your aaa.user1 data has some data item(s) in it that are longer than the field in usersalesrep.user1 will contain.-------Moo. :) |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-04-07 : 11:06:05
|
Oh, by the way, the temp user input table aaa has firstname and lastname cloumn names reversed from the real one. |
|
|
|
|
|
|
Update statement help