create index xs_kc_ind on xs_kc(sno,cno).sql

在学习SQL Server过程中整理的T-SQL语句

use test
if exists(select name from sysindexes where name='xs_kc_ind')
    drop index XS_KC.xs_kc_ind
go
create index xs_kc_ind on XS_KC(sno,cno)
go