表里有列CODE,VARCHAR(10)
现我想在这列的值后面加一个'_'
code
001
002
变
code
001_
002_用update TB1 set code=left(code+'_',10)
出现:
Server: Msg 8152, Level 16, State 9, Line 6
String or binary data would be truncated.
The statement has been terminated.
请教!
现我想在这列的值后面加一个'_'
code
001
002
变
code
001_
002_用update TB1 set code=left(code+'_',10)
出现:
Server: Msg 8152, Level 16, State 9, Line 6
String or binary data would be truncated.
The statement has been terminated.
请教!
set code=rtrim(code)+'_'
set code=ltrim(code)+'_'
用update TB1
set code=rtrim(code)+'_'
或update TB1
set code=Ltrim(code)+'_'
都提示上面的错误!
from TB1
where datalength(left(CODE+'_',10))>10
or len(left(CODE+'_',10))>10
select * from TB1 where len(code) in(select max(len(code)) from tb1)
--看看最大长度是多少?--更新
update TB1
set code=ltrim(rtrim(code))+'_'
where len(code)<10
就OK了,多谢大家!