sql 将截断字符串或二进制数据 错误
原因1、你输入字符串的长度,超过了你数据库能录入的长度，或类型不匹配
原因2、可能是使用了insert into...select from a join b语句，select from join中组合中有超长记录，尝试left join既可
例如：create table #tboc(organ_name varchar(20),lenname int,organ varchar(20),city varchar(5),prod_areas varchar(5),material varchar(20),subcompany varchar(20) )
insert into #tboc (organ_name,lenname,organ,city,prod_areas,material,subcompany
)
SELECT _d.organ_name,DATALENGTH(_d.organ_name) ,_a.organ,_a.city,_b.prod_areas,_c.material,_a.subcompany
FROM t_b_organ_city _a JOIN t_b_office_material_relation _b ON _a.organ=_b.office
JOIN t_b_material _c on _c.prod_areas=_b.prod_areas join t_b_organ _d on _d.organ=_a.organ
where _a.subcompany='DG101000' and _c.prod_areas<>'00'
评论