7.5.2.sql

清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码

USE School
IF NOT EXISTS (SELECT name FROM sysindexes WHERE name = 'st_ind')
CREATE INDEX st_ind ON STUDENTS(grade)
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
SELECT * FROM STUDENTS
WHERE grade=2000
SET STATISTICS IO OFF
GO
SET STATISTICS TIME OFF
GO