消息 241,级别 16,状态 1,第 1 行
从字符串转换日期和/或时间时,转换失败。是怎么回事?
insert into XSB
values('081101','王林','男','1990-02-10','计算机',50,null),
('081102','程明','男','1991-02-01','计算机',50,null),
('081103','王燕','女','1989-10-06','计算机',50,null),
('081104','韦严平','男','1990-08-26','计算机',50,null),
('081106','李方方','男','1990-11-20','计算机',50,null),
('081107','李明','男','1990-05-01','计算机',54,'提前修完《数据结构》,并获学分'),
('081108','林一帆','男','1989-08-05','计算机',52,'已提前修完一门课'),
……出生时间(date null)
哪里有问题呢???
从字符串转换日期和/或时间时,转换失败。是怎么回事?
insert into XSB
values('081101','王林','男','1990-02-10','计算机',50,null),
('081102','程明','男','1991-02-01','计算机',50,null),
('081103','王燕','女','1989-10-06','计算机',50,null),
('081104','韦严平','男','1990-08-26','计算机',50,null),
('081106','李方方','男','1990-11-20','计算机',50,null),
('081107','李明','男','1990-05-01','计算机',54,'提前修完《数据结构》,并获学分'),
('081108','林一帆','男','1989-08-05','计算机',52,'已提前修完一门课'),
……出生时间(date null)
哪里有问题呢???
insert into XSB
values('081101','王林','男','1990-02-10','计算机',50,null),
('081102','程明','男','1991-02-01','计算机',50,null),
('081103','王燕','女','1989-10-06','计算机',50,null),
('081104','韦严平','男','1990-08-26','计算机',50,null),
('081106','李方方','男','1990-11-20','计算机',50,null),
('081107','李明','男','1990-05-01','计算机',54,'提前修完《数据结构》,并获学分'),
('081108','林一帆','男','1989-08-05','计算机',52,'已提前修完一门课'),
('081109','张强民','男','1989-08-11','计算机',50,null),
('081110','张蔚','女','1991-07-22','计算机',50,'三好生'),
('081111','赵琳','女','1990-03-18','计算机',50,null),
('081113','严红','女','1989-08-11','计算机',48,'有一门课不及格,待补考'),
('081201','王敏','男','1989-16-10','通信工程',42,null),
('081202','王林','男','1989-01-29','通信工程',40,'有一门课不及格,待补考'),
('081203','王玉民','男','1990-03-26','通信工程',42,null),
('081204','马琳琳','女','1989-02-10','通信工程',42,null),
('081206','李计','男','1989-09-20','通信工程',42,null),
('081210','李红庆','男','1989-05-01','通信工程',44,'已提前修完一门课,并获学分'),
('081216','孙祥欣','男','1989-03-19','通信工程',42,null),
('081218','孙研','男','1990-10-09','通信工程',42,null),
('081220','吴薇华','女','1990-03-18','通信工程',42,null),
('081221','刘燕敏','女','1989-11-12','通信工程',42,null),
('081241','罗林琳','女','1990-01-30','通信工程',50,'转专业学习')
go
('081201','王敏','男','1989-16-10','通信工程',42,null),