出现截断字符串怎么办？？？急急急……

Question

use student
go
insert into student(sno,sname ,ssex ,sage ,sdept)
values
('200515001','赵菁菁','女',23,'CS'),
('200515002','李咏','男',20,'CS'),
('200515003','张力','男',19 ,'CS'),
('200515004','张衡','男',18,'IS'),
('200515005','张向东','男',20,'IS'),
('200515006','张向丽','女',20,'IS'),
('200515007','王芳','女',20,'CS'),
('200515008','王民生','男',25,'MA'),
('200515009','王小民','女',18,'MA'),
('200515010','李晨','女',22,'MA'),
('200515011','张毅','男',20,'WM'),
('200515012','杨磊','女',20,'EN'),
('200515013','李晨','女',19,'MA'),
('200515014','张丰毅',' 男',22,'CS'),
('200515015','李蕾','女',21,'EN'),
('200515016','刘社','男',21,'CM'),
('200515017','刘星耀','男',18,'CM'),
('200515018','李贵','男',19,'EN'),
('200515019','林自许','男',20,'WM'),
('200515020','马翔','男',21,null),
('200515021','刘峰','男',25,'CS'),
('200515022','牛站强','男',22,null),
('200515023','李婷婷','女',18,null),
('200515024','严丽','女',20,null),
('200515025','朱小鸥','女',30,'WM')

出现：消息 8152，级别 16，状态 14，第 2 行
将截断字符串或二进制数据。
语句已终止。

Answer 1

先看看表里字段定义的长度

然后分开插入看看
insert into student(sno,sname ,ssex ,sage ,sdept)
values
('200515001','赵菁菁','女',23,'CS')

insert into student(sno,sname ,ssex ,sage ,sdept)
values
('200515002','李咏','男',20,'CS')