7.3.2.sql

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

USE SCHOOL
IF NOT EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_sid’)
CREATE INDEX IX_sid 
ON CHOICES(SID)
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
select * from choices where sid like '800554358'
GO