7.2.2.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 14 行

USE School
IF NOT EXISTS (SELECT name FROM sysindexes 
      WHERE name = 'cs_cid_ind')
   CREATE INDEX cs_cid_ind 
   ON CHOICES(CID)
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
SELECT COUNT(*)
FROM CHOICES
WHERE cid=10040
GO