定义:CREATE [UNIQUE] [CLUSTER] INDEX <索引名>
ON <表名>(<列名>[<次序>][,<列名>[<次序>] ]…)
例子:Student,Course,SC三个表建立索引。其中Student表按学号升序建唯一索引,Course表按课程号升序建唯一索引,SC表按学号升序和课程号降序建唯一索引
CREATEUNIQUE INDEX S_Sno ON Student (Sno)
CREATEUNIQUE INDEX C_Cno ON Course(Cno)
CREATEUNIQUE INDEX SCno ON SC(Sno ASC,Cno DESC)
二.游标
定义:
DECLARE cursor_name [INSENSITIVE][SCROLL]CURSOR
FOR select_statement
FOR {READ ONLY|UPDATE|OF column_name[,...]]}]
例子:
USE db_2014 DECLARE Cur_Emp CURSORFORSELECT * FROM Employee
GO
USE db_2014
DECLARE Cur_Emp_01 CURSORFORSELECT * FROM Employee
FORREADONLYGO