create nonclustered index score_ind on xs(total).sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 7 行

use test
if exists(select name from sysindexes where name='score_ind')
     drop index XS.score_ind
go
create nonclustered index score_ind on XS(total)
       with fillfactor=3
go