语句没错,请检查RFQ是否是字符串型数据。或者更改为如下:
UPDATE SP_ChangRe_Details SET RFQ='1000'+cast(RFQ as varchar)+'00' where ECONO='ECO2911' and RFQ='6031'
UPDATE SP_ChangRe_Details SET RFQ='1000'+cast(RFQ as varchar)+'00' where ECONO='ECO2911' and RFQ='6031'
set [AID] = convert(varchar,'1000')+convert(varchar,AID)+convert(varchar,'00')
改为: RFQ='1000'+rtrim(RFQ)+'00'
如果'1000'+rtrim(RFQ)+'00' 的长度超过字段RFQ定义的长度,将出错