create table student(sno char(8)not null,sname char(10) not null,ssex char(1),sage int check(sage>=14),
sclass char(8),address char(10) primary key(sno) references class(classname)
)
insert into student values('j20001','李楷','m',19,'js2001','北京')
insert into student values('j20002','张会','f',20,'js2001','天津')
insert into student values('j20003','王者','m',20,'js2001','上海')
insert into student values('d20001','赵良','m',18,'dz2001','广洲')
select * from student
select top 2 * from student
select top 60 percent * from student
drop table student
sclass char(8),address char(10) primary key(sno) references class(classname)
)
insert into student values('j20001','李楷','m',19,'js2001','北京')
insert into student values('j20002','张会','f',20,'js2001','天津')
insert into student values('j20003','王者','m',20,'js2001','上海')
insert into student values('d20001','赵良','m',18,'dz2001','广洲')
select * from student
select top 2 * from student
select top 60 percent * from student
drop table student
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货