use mydb
go
create table student
(sno int NOT NULL primary key,
sname char(8),
sex char(2),
birth datetime,
height int,
class char(10),
address char(20)
)
go
insert into student
values(200200102,'魏永建','男','1982-4-1',163,'sc1','hebei');
go
insert into student
values(200200103,'张吉洲','男','1983-2-8',183,'sc1','shandong');
go
insert into student
values(200200104,'刘承波','男','1983-12-28',174,'sc1','shandong');
go
insert into student
values(200200105,'伍高学','男','1984-12-18',170,'sc1','hunan');
错误提示:
服务器: 消息 2627,级别 14,状态 1,行 1
违反了 PRIMARY KEY 约束 'PK__student__76CBA758'。不能在对象 'student' 中插入重复键。
语句已终止。