7.2.1.sql

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

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