sqlserver ÉÏ»úÁ·Ï°Ìâ

 create database db
use db
go
create table course
(
 sno varchar(20),
 cno int ,
 Gmark int
)
insert into course values('20071513115',1,80)
insert into course values('20071513114',2,80)
insert into course values('20071513113',3,80)
insert into course values('20071513112',4,80)
insert into course values('20071513111',1,80)
insert into course values('20071513110',2,80)
insert into course values('20071513116',3,80)
insert into course values('20071513117',1,80)
select  distinct cno from course
go
create table student
(sno char(7) not null primary key,
 sname varchar(20) not null,
 ssex char(2) not null,
 sage smalldatetime ,
 spno char(5),
 classid char(5),
 Inyear char(4) not null )
insert into student
values('2000101','ÀîÓÂ','ÄÐ','1980-7-1','00311','10497','1999')
insert into student
values('2000102','ÁõÊ«³¿','Å®','1981-8-12','00311','10498','1999')
insert into student
values('2000103','ÍõÒ»Ãù','ÄÐ','1982-12-20','00312','10497','2001')
insert into student
values('2000104','ÕÅæÃæÃ','Å®','1985-5-9','00312','10498','2000')
insert into student
values('2001101','ÀîÃô','Å®','1989-3-9','01311','10497','1999')
insert into student
values('2001102','¼ÖÏòÄÐ','Å®','1982-9-3','01311','10498','2000')
insert into student
values('2001103','³ÂÀ','ÄÐ','1981-5-7','01311','10497','1999')
insert into student
values('2000105','ÕÅÈý','ÄÐ','1984-6-7','01311','10497','1999')
insert into student
values('2000106','ÕÅ','ÄÐ','1984-6-7','01311','10497','1999')
select * from student where spno='01311' and  ssex='Å®'
go
select sname,ssex,sage from student where spno in('01311','01312')
go
select * from student where  sname like 'Àî%'
go