一个奇怪的 截断字符串或二进制数据报错

insert  b_vip_card
(vip_card_id,organ_id,allow_integral,vipcard_type,level,status,retail_amt,real_amt,cost_amt,integral,integral_all,
 holder,abc,address,sex,tel,mobile,id_number,birthday,birthday_type,create_time,create_user,modify_time,modify_user,
   apply_time,exp_date,operator,balance,balance2)select a.VIP卡号,'1001','1','1','1','1',isnull(b.消费总金额,0),isnull(b.消费总金额,0),'0',isnull(b.积点,0),isnull(b.积点,0),
   convert(varchar(18),a.会员名称),dbo.fu_GetPy(a.会员名称) as abc,convert(varchar(100),a.地址),'',a.电话号码,a.手机号码,a.身份证号,a.贵宾生日,'1',a.开卡时间,convert(varchar(10),168)as create_user,GETDATE(),convert(varchar(10),168)as create_user,a.开卡时间,'2099-12-31','',
   0.00,0.00 from tenp_vipcard_jk a left join temp_vipcard_jifen_jk b on a.VIP卡号 = b.会员卡号

 

截断字符串或二进制数据报错，报错点在提示在表名这里，字段无报错，琢磨了几个小时，加了四个covert就执行成功了。。。。没加之前也确定是没有超出的，