SQL server语句练习

insert into student (sno,sname,ssex,sbirthday,class)
values (105,'匡明','男','1975-10-02',95031)
insert into student(sno,sname,ssex,sbirthday,class)
values (107,'王丽','女','1976-01-23',95033)
insert into student(sno,sname,ssex,sbirthday,class)
values (101,'李军','男','1976-02-20',95033)
insert into student(sno,sname,ssex,sbirthday,class)
values (109,'王芳','女','1975-02-10',95031)
insert into student(sno,sname,ssex,sbirthday,class)
values (103,'陆军','男','1974-06-03',95031)
insert into course (cno,cname,tno) values ('3-105','计算机导论',825)
insert into course (cno,cname,tno) values ('3-245','操作系统',804)
insert into course (cno,cname,tno) values ('6-166','数据电路',856)
insert into course (cno,cname,tno) values ('9-888','高等数学',831)
 
insert into score (sno,cno,degree) values(103,'3-245',86)
insert into score (sno,cno,degree) values(105,'3-245',75)
insert into score (sno,cno,degree) values(109,'3-245',68)
insert into score (sno,cno,degree) values(103,'3-105',92)
insert into score (sno,cno,degree) values(105,'3-105',88)
insert into score (sno,cno,degree) values(109,'3-105',76)
insert into score (sno,cno,degree) values(101,'3-105',64)
insert into score (sno,cno,degree) values(107,'3-105',91)
insert into score (sno,cno,degree) values(108,'3-166',78)
insert into score (sno,cno,degree) values(101,'3-166',85)
insert into score (sno,cno,degree) values(107,'3-166',79)
insert into score (sno,cno,degree) values(108,'3-166',85)

insert into teacher (tno,tname,tsex,tbirthday,prof,depart) 
values(804,'李成','男','1958-12-02','副教授','计算机')
insert into teacher (tno,tname,tsex,tbirthday,prof,depart) 
values(856,'张旭','男','1969-03-12','讲师','电子工程')
insert into teacher (tno,tname,tsex,tbirthday,prof,depart) 
values(825,'王萍','女','1972-05-05','助教','计算机')
insert into teacher (tno,tname,tsex,tbirthday,prof,depart) 
values(831,'刘冰','女','1977-08-14','助教','电子工程')

delete from student
where sname ='李军'
truncate table student
update student set ssex='女'
select * from student where ssex='女'
select* from student where sname like'王%'