数据库实验习题2.1.sql

数据库第二章习题程序

/*(1)
USE SCHOOL
CREATE TABLE CLASSES(
CLASS_ID VARCHAR(4),
NAME VARCHAR(10),
DEPARTMENT VARCHAR(20),
CONSTRAINT PK_CLASSES PRIMARY KEY(CLASS_ID))
*/


/*(2)
USE SCHOOL
BEGIN TRANSACTION T3
INSERT INTO CLASSES VALUES('0001','MiaoMing','CS')
BEGIN TRANSACTION T4
INSERT INTO CLASSES VALUES('0001','MiaoMing','CS')
COMMIT TRANSACTION T4
COMMIT TRANSACTION T3
*/

/*SELECT * FROM CLASSES*/