插入溢出？？？

Question

28w不算大呀,可能是前台程序的事

Answer 1

insert srv_lnk.BDBackUp.dbo.pe_base
(pe_usename,sc_id,UserName,IDCard,Sex,Birth,
Native,Residence,RegDate,Info_Flag,KSH,Tel1,Tel2,BP,ICQ,HTTP,Email
,Work_Site,address,pc,other,Marry,PePhoto,Source,Faddress,Stature,
avoir,nation,pe_desc,polity,edc_level,University,enroll_time,CollegeID,
classid,Student_No,Specialty1,Specialty2,Study_Story,ability_cert,Px_Story,pyfs,
Tech_Level,xy,Specialty1_is_bada,Specialty2_is_bada,Sc_Specialty1,Sc_Specialty2)select a.pe_usename,a.sc_id,a.username,a.idcard,a.sex,a.birth,
a.Native,a.residence,b.regdate,a.info_flag,a.ksh,c.tel1,c.tel2,c.bp,c.icq,c.http,c.email,
c.work_site,c.address,c.pc,c.other,a.marry,a.pephoto,a.source,a.faddress,a.stature,
a.avoir,a.nation,d.pe_desc,a.polity,e.edc_level,e.University,e.enroll_time,e.CollegeID,
e.ClassID,e.Student_No,e.Specialty1,e.Specialty2,e.study_story,e.ability_cert,e.px_story,
e.pyfs,a.tech_level,e.xy,e.Specialty1_is_bada,e.Specialty2_is_bada,e.Sc_Specialty1,e.Sc_Specialty2 
 from pe_base a,pe_log b,pe_contact c,pe_desc d,pe_edc e,#t bb 
where a.PE_USENAME=bb.PE_USENAME and 
a.pe_usename=b.pe_usename
and a.pe_usename=c.pe_usename and a.pe_usename=d.pe_usename
and a.pe_usename=e.pe_usename 这样简单的sql语句应该没有问题呀！