sqlserver 上机练习题
来源:互联网 发布:波粒二象性知乎 编辑:程序博客网 时间:2024/04/30 15:42
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
- sqlserver 上机练习题
- SqlServer练习题
- 上机练习题参考题
- Sicily上机练习题
- 华为上机练习题
- 华为上机练习题
- SQL上机练习题2
- 上机练习题—继承
- lesson3 上机练习题-继承
- 寒假学生上机编程练习题
- 记录-数据结构第一章上机练习题
- 华为上机练习题--计算表达式
- 华为上机练习题--按位取反操作
- 华为上机练习题--压缩字符串
- 上机练习题——继承
- 上机练习题——接口
- 上机练习题——接口
- 上机练习题——接口
- check约束(备忘录)
- 利用putty从windows登录ubuntu9.10server
- MySQL数据库备份和还原的常用命令
- css 控制滚动条的颜色
- Hibernate为什么要重写equals和hashCode方法
- sqlserver 上机练习题
- wpf --自定义控件的transeform
- Java面试的经常问的40题
- 【连载】优秀程序员的 45 个习惯之习惯27
- 生命的含义
- Anychart 5.1.2 Flash图表控件免费下载
- 用路由器扩展局域网ip的方法
- 我是一只愚
- 浅谈家长怎样与孩子交流