jiaoxuedb1.sql

这是一个教学系统用SQL 2000编写的

use jiaoxuedb
select * from Teacher
select * from sysdatabases where name='jiaoxuedb'


INSERT INTO SC VALUES('S3','C2',70)
INSERT INTO SC VALUES('S3','C4',85)
INSERT INTO SC VALUES('S4','C2',85)
INSERT INTO SC VALUES('S4','C3',83)
INSERT INTO SC VALUES('S5','C2',89)

SELECT AGE,DEPT FROM STUDENT WHERE DEPT='计算机'
UPDATE STUDENT SET AGE=AGE+1 WHERE DEPT='计算机'
SELECT AGE,DEPT FROM STUDENT WHERE DEPT='计算机'

SELECT SNO,CNO,SCORE FROM SC WHERE SCORE<60

CREATE DATABASE MAKEUP_S
ON
(NAME='MAKEUP_MDF',
 FILENAME='G:\pw\MAKEUP.MDF',
 SIZE=5MB,
 FILEGROWTH=10%)
LOG ON
(NAME='MAKEUP_LDF',
 FILENAME='G:\pw\MAKEUP.LDF',
 SIZE=5MB,
 FILEGROWTH=10%)

CREATE TABLE MAKEUP_S (SNO CHAR(6) NOT NULL,
                CNO CHAR(5) NOT NULL,
                SCORE SMALLINT)

USE JIAOXUEDB
SELECT SNO,CNO,SCORE INTO MAKEUP_S FROM SC WHERE SCORE<60
DROP TABLE MAKEUP_S

DELETE FROM MAKEUP_S WHERE SCORE<20