求救各位高手

我的阿荣

免费乐捐，感谢支持

本人变了一个表 可是在插入数据时却出现了  如下错误 ：消息 8152，级别 16，状态 14，第 1 行
将截断字符串或二进制数据。
语句已终止。
   

编写表如下:
      create database Factory
use factory
CREATE TABLE S
(
  sno char(4)not null primary key ,
  sname varchar(8) not null,
  sage smallint,
  swage char(6),
  sdepartments char(2),
  sphone char(10),
  soffice char(6)

);


insert into s(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('1001','郑俊华',26,'1000',1,'8001234','1201#');
insert into s(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('1002','王平',27,'1200',1,'8001234','1201#');
insert into s(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('2001','王晓华',38,'1300',2,'8001235','2302#');
insert into s(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('2002','李力',24,'800',2,'8001236','2303#');
insert into s(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('3001','黎远军',42,'1300',3,'8001237','1202#');
insert into s(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('4001','李源',24,'800',4,'8001245','2402#');
insert into s(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('4002','李兴明',36,'1200',4,'8001246','2103#');

nj19900821

“将截断字符串或二进制数据” 这个代表你所插入的元组某个值超过了你之前建表时定义的属性长度

zzw9908

insert into S(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('1001','郑俊华',26,'1000','1','8001234','1201#')
insert into S(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('1002','王平',27,'1200','1','8001234','1201#')
insert into S(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('2001','王晓华',38,'1300','2','8001235','2302#')
insert into S(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('2002','李力',24,'800','2','8001236','2303#')
insert into S(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('3001','黎远军',42,'1300','3','8001237','1202#')
insert into S(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('4001','李源',24,'800','4','8001245','2402#')
insert into S(sno,sname,sage,swage,sdepartments,sphone,soffice)
values('4002','李兴明',36,'1200','4','8001246','2103#')