数据库应用/PowerBuilder课件下载

drop table XS; create table XS /*学生表*/ (学号 char(10) not null primary key, 姓名 char(10), 性别 char(2), 出生时间 datetime, 专业名 char(30), 总学分 decimal(5,1) ); insert into xs values('01','张三','男','1986-05-01','计算机',4.5); insert into xs values('02','李四','女','1987-05-01','计算机',null); insert into xs values('03','王五','女','1988-05-01','计算机',null); insert into xs values('04','赵六','男','1989-05-01','信息技术',null); insert into xs values('05','钱七','男','19890501','信息技术',null); drop table kc; create table kc /*课程表*/ (课程号 char(10) not null primary key, 课程名 char(40) null ); insert into kc values('01','高数'); insert into kc values('02','数据结构'); insert into kc values('03','汇编'); drop table XS_kc; create table XS_kc /*学生选课表*/ (学号 char(10) not null , 课程号 char(10) not null, 成绩 decimal(5,2) null, constraint pk_XS_kc primary key(学号,课程号) ); insert into XS_kc values('01','01',50); insert into XS_kc values('01','02',60); insert into XS_kc values('01','03',80); insert into XS_kc values('02','01',70); insert into XS_kc values('02','02',90); SELECT * INTO 计算机系学生 FROM XS WHERE 专业名= '计算机' SELECT * FROM XS UNION ALL SELECT * FROM 计算机系学生